公式

TODAY(-7))) Any help is…","categoryID":319,"dateInserted":"2017-12-29T15:16:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-03T19:21:52+00:00","insertUserID":27836,"insertUser":{"userID":27836,"name":"aelmore","url":"https:\/\/community.smartsheet.com\/profile\/aelmore","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-15T21:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":27836,"lastUser":{"userID":27836,"name":"aelmore","url":"https:\/\/community.smartsheet.com\/profile\/aelmore","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-15T21:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":6,"countViews":2316,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/17216\/countif-between-2-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17216\/countif-between-2-dates","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":17251,"type":"discussion","name":"Automatically Adding Subtasks","excerpt":"I am working to create a Kanban Sheet and Cardview for continuous projects that we do in our office. We have the same subtasks associated with each client through 3 various phases. Is there a way that when I add a new client or Primary\/Parent Task, that the same subtasks are automatically added? Thanks for your help!","categoryID":322,"dateInserted":"2018-01-02T16:08:02+00:00","dateUpdated":null,"dateLastComment":"2018-01-03T17:33:04+00:00","insertUserID":10580,"insertUser":{"userID":10580,"name":"Ashley Turrell","url":"https:\/\/community.smartsheet.com\/profile\/Ashley%20Turrell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-02T16:05:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1542,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/17251\/automatically-adding-subtasks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17251\/automatically-adding-subtasks","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":444,"urlcode":"card-view","name":"Card View"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":17211,"type":"discussion","name":"Forms and formulas","excerpt":"Hello, I am new to Smartsheets and am creating a form to send out and collect orders from customers. Now the form works but I need it to populate the new rows that get added with pricing from another sheet. Is this possible as I am not finding any info on this but then again I am new to the site. I would also like to know…","categoryID":319,"dateInserted":"2017-12-29T13:09:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-02T13:26:10+00:00","insertUserID":33401,"insertUser":{"userID":33401,"name":"elavoie","url":"https:\/\/community.smartsheet.com\/profile\/elavoie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-09T15:48:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":66,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/17211\/forms-and-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17211\/forms-and-formulas","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":5799,"type":"discussion","name":"LOOKUP() Function Help","excerpt":"I'm trying to write a function that will determine the county of an address based on the city. So far, I have created a table with several counties forming the vertical axis and then a list of all of the cities in each county running along the horizontal axis. It looks something like this: County 1 City1 City2 City3 County…","categoryID":318,"dateInserted":"2016-08-11T17:11:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-30T21:27:50+00:00","insertUserID":7902,"insertUser":{"userID":7902,"name":"John Isenhower","url":"https:\/\/community.smartsheet.com\/profile\/John%20Isenhower","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-03-14T20:56:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":33436,"lastUser":{"userID":33436,"name":"qgarrett","url":"https:\/\/community.smartsheet.com\/profile\/qgarrett","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZLDamawQbGY!g6lM5_QnBDo!Z7BaHC4MSkY","dateLastActive":"2022-12-19T16:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":2106,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/5799\/lookup-function-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5799\/lookup-function-help","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":17186,"type":"discussion","name":"How can I select data that is older than 365 day?","excerpt":"How can I select data that is older than 365 day? =COUNTIFS(Product:Product, \"ABC\", [Project Complete Date]:[Project Complete Date], \"Where Project Complete Date is < 365 days from today\" ","categoryID":319,"dateInserted":"2017-12-28T19:25:26+00:00","dateUpdated":null,"dateLastComment":"2017-12-29T12:39:10+00:00","insertUserID":33236,"insertUser":{"userID":33236,"name":"Anil","url":"https:\/\/community.smartsheet.com\/profile\/Anil","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-12-26T12:27:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":33236,"lastUser":{"userID":33236,"name":"Anil","url":"https:\/\/community.smartsheet.com\/profile\/Anil","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-12-26T12:27:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":2,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/17186\/how-can-i-select-data-that-is-older-than-365-day","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17186\/how-can-i-select-data-that-is-older-than-365-day","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":17126,"type":"discussion","name":"Change RYG Automatically based on values","excerpt":"Hello – I am trying to create a formula that will change RYG automatically with the following criteria: Green: Any positive (%) Yellow: 0 to negative 10% Red: less than negative 10% With the below formula, green and yellow work fine but not red. How close am I? =IF([% OVER (-) UNDER (+)]5 > 0, \"Green\", IF([% OVER (-) UNDER…","categoryID":319,"dateInserted":"2017-12-27T07:30:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-29T12:23:42+00:00","insertUserID":17811,"insertUser":{"userID":17811,"name":"afineline","url":"https:\/\/community.smartsheet.com\/profile\/afineline","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-09T07:57:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":17811,"lastUser":{"userID":17811,"name":"afineline","url":"https:\/\/community.smartsheet.com\/profile\/afineline","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-09T07:57:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":1,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/17126\/change-ryg-automatically-based-on-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17126\/change-ryg-automatically-based-on-values","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">