Can a threshold be set in a Formula or Widget to limit information displayed on a dashboard graph.
Hello,
I am trying to set a threshold to limit the amount of information that is displayed on a dashboard widget. I currently have multiple rows of different companies and multiple columns of observation categories (In a graph setup). The populating information is being pulled in using a formula from multiple columns in another sheet.
(Formula example.... =SUM(COUNTIFS({Example Range 1}, "Negative", {Example Range 6}, "Environmental", {Example Range 9}, "Company A"), SUM(COUNTIFS({Example Range 3}, "Negative", {Example Range 4}, "Environmental", {Example Range 10}, "Company A"), SUM(COUNTIFS({Example Range 5}, "Negative", {Example Range 18}, "Environmental", {Example Range 11}, "Company A"), SUM(COUNTIFS({Example Range 7}, "Negative", {Example Range 8}, "Environmental", {Example Range 12}, "Company A")))))
To simplify, my end goal is to display a bar graph on the dashboard that shows when there have been 3 of the same observations for the same company.
Thanks!
Best Answer
-
You will need to create a series of helper columns (one for each of the existing output columns) and use a basic IF statement to only output the number if it is greater than or equal to 3.
=IF([Column Name]@row>= 3, [Column name]@row)
Then you would create a report that pulls in these helper columns filtered to only show rows where at least one of those columns is not blank.
Finally you would use this report to create your chart.
Answers
-
Are you able to provide screenshots for context?
-
The first is where the graph data is being pulled from (Each cell is a sum of 4 different columns from another sheet), in the second graph, I would only like it to populate if there are a total of three of the same observations as seen with the conditional formatting. Hope this helps!
-
You will need to create a series of helper columns (one for each of the existing output columns) and use a basic IF statement to only output the number if it is greater than or equal to 3.
=IF([Column Name]@row>= 3, [Column name]@row)
Then you would create a report that pulls in these helper columns filtered to only show rows where at least one of those columns is not blank.
Finally you would use this report to create your chart.
-
Thanks!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!