Formulas

1; IF(due_date15 - planned_date15 > 0; \"Red\"; IF(due_date15 - planned_date15 > -3; \"Yellow\"; \"Green\"))) But now I would like to include a blue ball when the \"finish\" checkbox is checked. I tried some alternatives,…","categoryID":322,"dateInserted":"2018-05-29T18:39:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-30T01:46:32+00:00","insertUserID":44736,"insertUser":{"userID":44736,"name":"vanzin","url":"https:\/\/community.smartsheet.com\/profile\/vanzin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-05\/8f\/64\/n8f6494f8ce88c7dd1e852dc637bf22b7.png","dateLastActive":"2018-05-29T18:38:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":65,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/26071\/rygb-x-checkbox-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26071\/rygb-x-checkbox-question","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":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":25981,"type":"discussion","name":"How to reference the ","excerpt":"Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, ) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet. I have tried adding an…","categoryID":322,"dateInserted":"2018-05-28T21:07:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-29T23:02:07+00:00","insertUserID":49231,"insertUser":{"userID":49231,"name":"BP97","url":"https:\/\/community.smartsheet.com\/profile\/BP97","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-28T18:56:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":10908,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/25981\/how-to-reference-the","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25981\/how-to-reference-the","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":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"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}">

using Harvey ball status to drive a formula
Hi, Is there a way to use the harvey ball status to drive a formula? Here's an example of what I was able to achieve in excel but cannot replicate in Smart Sheet. =If(HarveyBall = "Full",date-today(),"") Result in excel, I get blank if result is true Result in SmartSheet, I get #Unparseable Observation is that the…
Help with a formula: Do not run formula if cell is blank
Rookie here -- I'm hoping to get some help with a formula issue. I am trying to flag the "Attn" column if "Days Until Due" is less than 120. However, I don't want the "Attn" column to flag if the cell is blank. I currently have this formula configured for the Attn column, which has the flag symbol: =IF([Days Until Due]1 <…
Formula for last 24 hours
Hello my friends - I need to create a formula to find any new rows added to a sheet in the last 24 hours. My created on system column is added. We currently are using the TODAY function, however, that only captures those added today, which leaves out a great deal of data when generating a report in the early a.m. hours. If…
Date validation on Web Form
Is there a way to validate a date before submitting a form. The Use-case is: We have an Event Request Date (Date field) on the form and we don't want the end client to select the close-by dates. We want to add a condition on the form; so, they can't select an Event day within a week, before they submit the form. Thanks J
SUMIF Formula - "Dragging" to Copy
For the formula below, when I drag this formula, which references another sheet, across columns in the sheet that I'm writing it, the column referenced in the formula doesn't change. Even though I've done nothing to anchor it, it just remains anchored on the column against which I wrote the original formula, in this case…
Lookup reference in another row referenced
Hello, Possibly this cannot be done in Smartsheet. I am trying to port over our drawing list coordination sheet from excel to Smartsheet. The formula uses Lookup in Excel - actual revision number to find on the same row that number - then return the date of that column from the first row of the sheet. The excel formula is…
Enhancement Request: Sheet/Workspace Level References in Formulas
I would like to create notifications for the creation of new sheets in specific workspaces and in general better track what sheets are getting created where. To this point I would like to build a master sheet with drop downs for each workspace showing what folders and sheets are in them. A directory if you will. This would…
Check Flag with formula
我试图打开的佛rmula. I am using the below, my problem is that the flag does not turn red, when I enter the formula the flag disappears and I get a 1. When I take the flag formatting off and change it to text I get "true" and then turn the flags back on I get my red flags, but then I try it again in…
RYGB X Checkbox question
Hello again Community! I currently use the following formula for our projects: (Works well!) =IF(Finish15 <> 1; IF(due_date15 - planned_date15 > 0; "Red"; IF(due_date15 - planned_date15 > -3; "Yellow"; "Green"))) But now I would like to include a blue ball when the "finish" checkbox is checked. I tried some alternatives,…
How to reference the
Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, ) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet. I have tried adding an…

Formulas

Discussion List