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
Luis Vega ✭✭✭
edited 12/09/19 in Archived 2017 Posts

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

This discussion has been closed.