How do I use a formula to auto-check a checkbox?

Options

I'm trying to figure out how to auto-check a checkbox in the complete column, when the status column contains "Complete". Please help. I was trying something like below, but it wasn't working.

=IF(Status@row = "Complete", Complete@row = 1, 0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!