Status Automation Based on the Number Of Check Boxes

Anthony Barthelemy

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

Bassam Khalil

Hi @Anthony Barthelemy

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

Paul Newcome

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"))

Anthony Barthelemy

@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

Paul Newcome

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"))