Need Help with Invalid Operation

Options

I'm getting Invalid Operation with this formula since the division equation is dividing by zero. How do I fix this so that it shows like "0 of 0 (0%)". If this isn't possible then I'd like to have "Not Yet Started" as the text entered.

=COUNTIF(CHILDREN(), >0) + " of " + [Clock In Location]@row + " (" + (ROUND(COUNTIF(CHILDREN(), >0) / (COUNT(CHILDREN([Clock In Location]1)) / 100)) + "%)" + "")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!