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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!