Formulas Done vs Complete

Options

With the formulas I currently have they work just fine. The small detail is that when they are not completed it says "2 of 3 Done" but when completed it says "6 of 6 Completed" (See screenshot). I know its minor but I was hoping to for a way to keep it consistent either all Done or all Complete.


These are the formulas I used. I tried changing them around but when I do it either says #UNPARSEABLE or the black line "1 of 4 Done" stops accurately keeping track. Does anyone know an easy way to get this fixed?

=COUNTIFS(CHILDREN(), CONTAINS("Complete", @cell)) + " of " + COUNT(CHILDREN()) + " Done"

=IF(COUNT(CHILDREN([Planning Done]@row)) = COUNTIF(CHILDREN([Planning Done]@row), 1), COUNTIFS(CHILDREN([Planning Done]@row), 1) + " of " + COUNT(CHILDREN([Task/Topic]@row)) + " Complete", COUNTIFS(CHILDREN([Planning Done]@row), 1) + " of " + COUNT(CHILDREN([Task/Topic]@row)) + " Done")


Thanks!


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!