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?
Help Article Resources
Check out the Formula Handbook template!