Formulas and Functions

0.1, \"Red\", IF([Schedule Delta (%)]@row > 0, \"Yellow\", \"Green\")) My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas…","categoryID":322,"dateInserted":"2020-07-30T07:31:31+00:00","dateUpdated":null,"dateLastComment":"2020-07-30T13:21:56+00:00","insertUserID":90421,"insertUser":{"userID":90421,"name":"leezee","url":"https:\/\/community.smartsheet.com\/profile\/leezee","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-5nbN5niI7w!ut1bd0G_liQ!GPE81z71hCx","dateLastActive":"2021-03-12T11:13:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":302,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70241\/project-health-calculation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70241\/project-health-calculation","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70244,"type":"question","name":"How do I do a row request?","excerpt":"I am trying to create groups of tasks that can be used by using a filter. Unfortunately I need to be able to know the row# of all added rows in order to have the new rows visible for each group. I want to have a cell that marks the start of a section and one that marks the end. The ones between need to be filled with the…","categoryID":322,"dateInserted":"2020-07-30T12:25:36+00:00","dateUpdated":null,"dateLastComment":"2020-07-30T13:18:55+00:00","insertUserID":117878,"insertUser":{"userID":117878,"name":"Joshua Bruck","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Bruck","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-23T12:39:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":52,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70244\/how-do-i-do-a-row-request","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70244\/how-do-i-do-a-row-request","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70233,"type":"question","name":"COUNTIFS Referencing another sheet and pulling data from a specific time period","excerpt":"Hello, I am trying to create a formula that will pull the number of times an entry was submitted for a specific location from another sheet, but I want to set the date it should start counting from and no end date. The data that the formula will compute I will then use as a reference cell for a chart I created on a…","categoryID":322,"dateInserted":"2020-07-29T21:25:34+00:00","dateUpdated":null,"dateLastComment":"2020-07-30T12:51:34+00:00","insertUserID":124676,"insertUser":{"userID":124676,"name":"Brenda Monroy","url":"https:\/\/community.smartsheet.com\/profile\/Brenda%20Monroy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-18T17:07:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":154,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70233\/countifs-referencing-another-sheet-and-pulling-data-from-a-specific-time-period","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70233\/countifs-referencing-another-sheet-and-pulling-data-from-a-specific-time-period","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70187,"type":"question","name":"Help w\/ COUNTIFS and ISBLANK and NOT ISBLANK","excerpt":"Hi team - I have 2 columns (Seat and Open Req) that I need to count: When Seat = Filled and Open Req is not blank When Seat = Filled and Open Req is blank I'm struggling with the COUNTIFS sequence to get this to work. Any help would be greatly appreciated.","categoryID":322,"dateInserted":"2020-07-28T15:42:59+00:00","dateUpdated":null,"dateLastComment":"2020-07-30T11:46:17+00:00","insertUserID":118864,"insertUser":{"userID":118864,"name":"jmo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!g0lA5zVbOLw!-wfAd_lcHz4!voKaS5U1cZv","dateLastActive":"2023-01-17T16:39:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":2065,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/70187\/help-w-countifs-and-isblank-and-not-isblank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70187\/help-w-countifs-and-isblank-and-not-isblank","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70232,"type":"question","name":"Project stage and date in the Future","excerpt":"Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria. Recurring On hold Pending approval + In Progress with a Go-Live date of after 3\/31\/21 The Recurring is its own checkbox without a formula, the On Hold,…","categoryID":322,"dateInserted":"2020-07-29T21:01:24+00:00","dateUpdated":null,"dateLastComment":"2020-07-29T22:12:34+00:00","insertUserID":124674,"insertUser":{"userID":124674,"name":"Krista Coffman","url":"https:\/\/community.smartsheet.com\/profile\/Krista%20Coffman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!82FbN2Xh-no!mj_Yn33NW_4!EFRqdhPpbc5","dateLastActive":"2023-08-09T22:59:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":124674,"lastUser":{"userID":124674,"name":"Krista Coffman","url":"https:\/\/community.smartsheet.com\/profile\/Krista%20Coffman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!82FbN2Xh-no!mj_Yn33NW_4!EFRqdhPpbc5","dateLastActive":"2023-08-09T22:59:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":63,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70232\/project-stage-and-date-in-the-future","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70232\/project-stage-and-date-in-the-future","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-29T22:12:12+00:00","dateAnswered":"2020-07-29T21:25:02+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":210,"urlcode":"human-resources","name":"Human Resources"},{"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":70192,"type":"question","name":"Formula to Automatically Return Column Pending","excerpt":"I have a Smartsheet that is being used to login dates as an item is processed through various steps until completion. I would like to create a column that automatically shows what step in the process the item is on. I can do this by combining if\/then formulas, but there are at least 15 steps and I am hoping there might be…","categoryID":322,"dateInserted":"2020-07-28T17:53:31+00:00","dateUpdated":null,"dateLastComment":"2020-07-29T19:51:33+00:00","insertUserID":76111,"insertUser":{"userID":76111,"name":"Jennifer C","url":"https:\/\/community.smartsheet.com\/profile\/Jennifer%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-15T15:52:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":104,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/70192\/formula-to-automatically-return-column-pending","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70192\/formula-to-automatically-return-column-pending","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-29T19:26:07+00:00","dateAnswered":"2020-07-28T19:13:32+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":70223,"type":"question","name":"How can I add days to dates based on text in another column?","excerpt":"I need to have a specific number of days added to a date that is in Column A, and have it add days to Column C, based on the text that is in Column B. Example: Column A is SC (needs +20) Column B is 7\/29\/2020 Column C should = 8\/18\/2020 I have found that (A1,\"SC\",B1)+20 works per text, but I have 12 different variances of…","categoryID":322,"dateInserted":"2020-07-29T18:06:56+00:00","dateUpdated":null,"dateLastComment":"2020-07-29T18:50:54+00:00","insertUserID":124662,"insertUser":{"userID":124662,"name":"Sean Dawson","url":"https:\/\/community.smartsheet.com\/profile\/Sean%20Dawson","photoUrl":"https:\/\/lh6.googleusercontent.com\/-QV8_b60-UvY\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuuclBU_UZlgxKVDH3pSEj8YTwkhhEKA\/photo.jpg","dateLastActive":"2020-07-29T18:59:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":294,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70223\/how-can-i-add-days-to-dates-based-on-text-in-another-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70223\/how-can-i-add-days-to-dates-based-on-text-in-another-column","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}">

Help Article Resources