Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Checkbox N/A % roll up
Luis Vega
✭✭✭
HI,
Was hoping to modify this fomula to ignore N/A cells (in turn, removing the cell from the % rollup) in a checkbox column.
=ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0, COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()), 0) * 100, 0) + "%"
appreciate it!
Comments
-
Luis,
This should work:
=ROUND(IF(COUNT(CHILDREN()) > 0, COUNTIF(CHILDREN(), 1) / (COUNT(CHILDREN()) - COUNTIF(CHILDREN(), "N/A")), 0) * 100, 0) + "%"
Note that I changed your IF condition as you likely don't need to determine if the count percentage > 0 but rather that you have children at all.
Craig
-
Huge thanks Craig!
This discussion has been closed.