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(children()) with filter or in reports
Hi there,
is it possible to get the sum or count of a filtered sheet or in a report?
I want to know how many lines are filled with data. I use the count(children()) function. In one cell are the nicks of the employees (like "KOV, SEA, KEP ..."). Now I set a filter that only shows me lines where "KEP" is in this string. In the parent line should the number of lines appear ...
without filter:
filtered "HUJ" (the number should change to less than 17):
many thanks
Peter
Comments
-
As far as I know, a formula will include values of filtered data. A filter doesn't remove data it simply hides it from view. A quick test adding numbers in a column returned a value of 14. When I filtered a few of the numbers out, the value of the formula was still 14. Perhaps you could use a checkbox column that included a formula that if the test was positive, would check the box. Then create an additional formula that summed the number of check boxes.
-
many thanks ... got the same result which is not good ...
