Is there a formula to check a box if a, b, c are done?

Tammi C

Is there a way to have the Agency Approved column automatically check if all the columns to the left are checked?

I noticed the new automation to update a cell is only for OR conditions not AND.

Andrée Starå

Hi @Tammi C

I hope you're well and safe!

Try something like this.

=IF(COUNTIF([Reviewed/ No Edits]@row:[EVAC Status Updated = Approved]@row, <>0)
 = COUNT([Reviewed/ No Edits]@row:[EVAC Status Updated = Approved]@row), 1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Tammi C

I hope you're well and safe!

Try something like this.

=IF(COUNTIF([Reviewed/ No Edits]@row:[EVAC Status Updated = Approved]@row, <>0)
 = COUNT([Reviewed/ No Edits]@row:[EVAC Status Updated = Approved]@row), 1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Tammi C

@Andrée Starå - that formula worked great! How would I add an OR to that?

I want the column formula for Agency Approved to be:

=IF(COUNTIF([Reviewed/ Edits Needed]@row:[EVAC Status Updated = Approved]@row, <>0)
 = COUNT([Reviewed/ Edits Needed]@row:[EVAC Status Updated = Approved]@row), 1)

or

=IF(Countif.... Reviewed/ No Edits is checked, Zone Approved is checked and EVAC Status Updated is checked to mark Agency approved as checked.

Tried a few variations and kept coming up with errors. Thanks