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
Check out the Formula Handbook template!