2

We're using Smartsheets to track our projects through the production process. We have one sheet that is just a list of the items, with 6 check boxes signaling that portion is complete. When all 6 check boxes are marked "checked"/true, I'd like the last column to automatically update as "completed." I've looked around and tried some "if" formulas, but nothing has been fitting my needs. 

Comments

SEAN WILLIAMS

Hey Amanda - 

Do you mean that the 6 checkboxes are 6 checkbox columns on the 1 row or 6 rows with 1 checkboax column?



Sean

Hi Amanda,

Try something like this if the checkboxes are on the same row.

EDIT: If you want the text Completed instead of a checkbox getting checked you can replace the last 1 in the formulas to "Completed".

Replace A to F with your column names.

=IF(COUNTIF([email protected]:[email protected]; 1) = 6; 1)

The same version but with the below changes for your and others convenience.

=IF(COUNTIF([email protected]:[email protected], 1) = 6, 1)

Try this if it's in the same column.

Replace A with your column name.

=IF(COUNTIF(A1:A6; 1) = 6; 1)

The same version but with the below changes for your and others convenience.

=IF(COUNTIF(A1:A6, 1) = 6, 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting