Can a threshold be set in a Formula or Widget to limit information displayed on a dashboard graph.



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.


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!