Formula to automatically tick the checklist box if the status has been marked as "completed"

Leah Mayes

Hi all

Is there an IF statement or a formula that can do the above? Rather than manually ticking the box

Thanks :)

Debbie Sawyer

Yes, pop this function into the checkbox cell (this function is based on a column called Status having a text value called Completed stored within it.

=IF([Status]@row="Completed",1,0)

If you would rather work from % Complete then update the formula to be:

=IF([%Complete]@row=1,1,0)

Hope this helps

Kind regards

Debbie Sawyer Consultant & Training Manager

 

Debbie Sawyer

Yes, pop this function into the checkbox cell (this function is based on a column called Status having a text value called Completed stored within it.

=IF([Status]@row="Completed",1,0)

If you would rather work from % Complete then update the formula to be:

=IF([%Complete]@row=1,1,0)

Hope this helps

Kind regards

Debbie Sawyer Consultant & Training Manager

 

Andrée Starå

Hi Leah,

Yes, there is.

Try something like this.

=IF(Status@row = "Completed"; 1; 0)

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

=IF(Status@row = "Completed", 1, 0)

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

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Leah Mayes

Thank you so much!

Andrée Starå

@Leah Mayes

Happy to help!

Liz_Snavely