Smartsheet Checkbox

Psaul Henry

Hi there,

I want to find a formula that works for the following conditions for a checkbox column.

If no cells are checked enter "Not Started"

If one or more cells are checked enter "In Progress"

If all cells are checked enter "Complete".

I need all three conditions to be included in a single formula.

James Keuning

Create an autonumber system field named ROWID and name your checkbox field Checkbox

=IF(COUNTIFS(Checkbox:Checkbox, true, [Row ID]:[Row ID], @cell > 0) = COUNT([Row ID]:[Row ID]), "complete", IF(COUNTIFS(Checkbox:Checkbox, false, [Row ID]:[Row ID], @cell > 0) = COUNT([Row ID]:[Row ID]), "not started", "In Progress"))

This counts your rows. Then it counts the checked boxes. It total checked boxes equals total rows, then complete. It total unchecked boxes equals total rows, then not started. Otherwise, In Progress.

James Keuning

Create an autonumber system field named ROWID and name your checkbox field Checkbox

=IF(COUNTIFS(Checkbox:Checkbox, true, [Row ID]:[Row ID], @cell > 0) = COUNT([Row ID]:[Row ID]), "complete", IF(COUNTIFS(Checkbox:Checkbox, false, [Row ID]:[Row ID], @cell > 0) = COUNT([Row ID]:[Row ID]), "not started", "In Progress"))

This counts your rows. Then it counts the checked boxes. It total checked boxes equals total rows, then complete. It total unchecked boxes equals total rows, then not started. Otherwise, In Progress.