Archived 2017 Posts
Archived 2017 Posts
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 ...
