Formula to check a box or to change status

Kelly S
Kelly S ✭✭✭✭


Two of my columns are Status (dropdown options) and Done(checkbox). I currently have an automated work flow sending out alerts if the Done box is not checked. I only want my users to have to change the Status column to "Complete" and then the Done box automatically get checked.

I was trying this to no avail: =IF(([STATUS]@ROW)= 'COMPLETED', 1,0)

Obviously I'm new to Smartsheet and Formulas πŸ˜ƒ. Your help is greatly appreciated.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!