Series of Checkboxes triggers complete

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.

Find more posts tagged with

Formulas

Project Management

Media & Entertainment

Email Notifications

Comments

sean59916

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

Andrée Starå

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(A@row:F@row; 1) = 6; 1)

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

=IF(COUNTIF(A@row:F@row, 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

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…