Change Status based on Checkbox
I'm new to smartsheet and really beginner at writing formulas I'm not well versed in AND/OR formulas. I tried looking it up, but my search came up empty.
I want to create a formula that when a check box is clicked that it automatically changes the status.
I have a Start check box and a Done Check box. When the Start checkbox isn't clicked I want the status to be "Not Started". When the Start check box is clicked I want the status to change to "In Progress". And finally when the Done checkbox is clicked I want the status to change to "Complete". What would the formula be?
Best Answer
-
Hey @Caitlin Goodman
If I understand you correctly, we'll only have to use Nested IFs for this formula vs also incorporating the AND/ORs.
When thinking about Nested IFs, we first look for any conditions that, no matter what, will drive the outcome. This is because IF statements progress through the formulas until they reach the first True. The formula stops executing at that point. Therefore the sequencing of the IFs become important.
=IF([Done checkbox]@row =1, "Complete", IF([Start checkbox]=1, "In Progress", "Not Started"))
Answers
-
Hey @Caitlin Goodman
If I understand you correctly, we'll only have to use Nested IFs for this formula vs also incorporating the AND/ORs.
When thinking about Nested IFs, we first look for any conditions that, no matter what, will drive the outcome. This is because IF statements progress through the formulas until they reach the first True. The formula stops executing at that point. Therefore the sequencing of the IFs become important.
=IF([Done checkbox]@row =1, "Complete", IF([Start checkbox]=1, "In Progress", "Not Started"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!