If Then Function
Our Smartsheet form has a “Completed” column (it is a date column) and a “Status” column (statuses from a drowndown list). We would like to somehow tell the sheet that, if the “Completed” cell is a date then change the status to “Completed” in the “Status” column. Basically when users submit a new form, the status goes in as "New", as people complete the task they submitted a form for we ask that the enter a completion date in the "Completed" column but when they enter a date in that field the status remain as "New". Is there a way to change the status of all the rows IF the completed cell of each row has a date? We would need this function to apply automatically to all rows of our sheet. Thank you.
Comments
-
You could use a formula like this in your status column:
IF(ISDATE(Completed@row), "Completed", "New")
Although, that will mark all the blank rows "New" as well. If you want those to stay blank, you could use a formula like this (change Primary to the name of your primary column):
=IF(ISBLANK(Primary@row), "", IF(ISDATE(Completed@row), "Completed", "New"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!