How to sum column totals for visible rows only?

Options

Hello,

I currently have a checkbox that allows a row to be filtered out (i.e. out of scope items). When these rows are filtered, I would like the associated numbers to not be included in the column sum totals. I tried searching but I must not be searching the right terms to find help on this function.

Any help appreciated!

Nate


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!