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!