Dashboard Charting Problem

Darrick Ferrington
Darrick Ferrington ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Is there a way to exclude cells that have a zero from charting? The bar chart does not show any data, but the topic headers, that have a zero, are cluttering the legend. If there is no data >0, I really would like the legend to not show the headers.

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I generally use an IF statement for this...

     

    IF(original formula > 0, original formula, "")

     

    This says that if the returned result from my formula is greater than zero, display the returned result, otherwise leave blank.

    thinkspi.com

  • Faye Kennedy
    edited 03/13/21

    I did this and the formula worked, but my chart widget in the dashboard is still displaying the blanks. Any ideas?