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.
Sum of column items respecting the filter
I've started using Smartsheet recently, so I am sorry if this is a newbie question I've tried to search for a solution, but nothing specific about this came up.
Anyway, I got the column SUM as open-ended, summing all rows correctly.
But when I enable a filter, for example only seeing rows in last 60 days, the sum amount remains the same. I understand that the columns are only hidden while the filter is active, so the SUM formula always counts on them.
Let me know if there is a way to go around this and how, I would like the SUM to be 'dynamic' showing me only the amount of rows I have visible.
a great software btw!
thanks in advance