Formula with COUNTIF and Checkbox

DanielGD · 03/31/19

I have this working formula:

="Unit 2G is " + ROUND((COUNTIF([Unit Name]:[Unit Name], "2G") / 14) * 100) + "% Completed"

2G could also be 3G, 4H, and 2H. (Dropdown selection list)

I have a checkbox column named: "Task Completed?"

How would I use the working formula to not do the calculation until the checkbox is "Checked"

Thanks

Andrée Starå · 03/31/19

Hi Daniel,

Try something along the line of.

=IF([Task Completed]@row= 1; "Unit 2G is " + ROUND((COUNTIF([Unit Name]:[Unit Name]; "2G") / 14) * 100) + "% Completed")

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

=IF([Task Completed]@row= 1, "Unit 2G is " + ROUND((COUNTIF([Unit Name]:[Unit Name], "2G") / 14) * 100) + "% Completed")

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 week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ricki · 04/01/19

You could also use the countifs formula to do something like this

="Unit 2G is " + ROUND((COUNTIFS([Unit Name]:[Unit Name], "2G",[Task Completed]:[Task Completed],1) / 14) * 100) + "% Completed"

Comments