# Status Automation Based on the Number Of Check Boxes

Options
✭✭✭✭✭✭

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

Thanks

• ✭✭✭✭✭✭
Options

Hope you are fine, could you please add a screenshot for your sheet or tell me what is the number of you checkbox column?

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Try something like this...

=IF(COUNTIFS(TS3:[Contractor Access]3, @cell = 1) = 0, "Not Started", IF(COUNTIFS(TS3:[Contractor Access]3, @cell = 1) = COUNTIFS(TS3:[Contractor Access]3, OR(@cell = 1, @cell <> 1)), "Complete", "Not Started"))

• ✭✭✭✭✭✭
Options

@Paul Newcome Close but I am Missing the In Progress Status.

If One Box is Checked, it should be In Progress.

If ALL the Boxes are Checked it Should be Complete

If None of the Boxes are Checked, it Should Be Not Started

• ✭✭✭✭✭✭
Options

Sorry about that. Fingers got away from me for a second.

=IF(COUNTIFS(TS3:[Contractor Access]3, @cell = 1) = 0, "Not Started", IF(COUNTIFS(TS3:[Contractor Access]3, @cell = 1) = COUNTIFS(TS3:[Contractor Access]3, OR(@cell = 1, @cell <> 1)), "Complete", "In Progress"))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!