Exclude one item for the count

Tribeiro
Tribeiro ✭✭✭
edited 12/09/19 in Smartsheet Basics

how can I exclude N/A on the count if N/A is selected

 

Formula:

=COUNTIF(CHILDREN(), "Done") + "/" + COUNT(CHILDREN()) + " (" + ROUND(COUNTIF(CHILDREN(), "Done") / COUNT(CHILDREN()) * 100) + "%)"

Screen Shot 2019-04-19 at 10.34.36 AM.png

Comments