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"