Status Automation Based on the Number Of Check Boxes


Good Day Smartsheet Community:

I need a little help on Adding to My Formula Below:

=IF(COUNTIF(TS3:[Contractor Access]3, =0), "Not Started", "In Progress"

I would like to Add that If All Checkboxes are Checked then Complete

If 1 Checkbox is Checked then In Progress

If 0 Checkboxes then Not Started



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!