Sign in to join the conversation:
Hi, want to count "at risk" check boxes to present at a dashboard.
so I thought fx=COUNTIF(Status2:Status14, "red") works, but it only produces 0 as result
Any suggestion
Thanks
Hi Andreas,
If you are using the Red Yellow Green symbol columns, you'll want to use this;
=COUNTIF([Status]2:[Status]14, "Red") - the capitalization matters.
If you are using a checkbox column, use this formula:
=COUNTIF([Status]2:[Status]14, 1)
Best,Kara
This discussion was created from comments split from: Plan Asset Manager - will it capture orphaned assets already in the system?.
In the new USM, are users who are designated as Viewers only able to download/export sheets they are given access to e.g. to Excel?
I just tried to create my first dashboard using the timeline chart widget. I have set it to open the source data when clicked however it does not work. I've done this multiple times without success. It seems this is not actually an option even though you can select it in the settings. Can someone verify this or is there…
