Invalid Column Value On Dashboard

I am trying to create a widget that displays a counts of days since last incident. Since some locations have not yet reported an incident I am getting this error.

For the sake of making a clean presentation is there something I can do to alter my formula to display a placeholder? I would settle for a "0" but a text like "N/A" would be nice.


=TODAY() - MAX(COLLECT({Incident Date.}, {Region}, "Warehouse", {GB Lost Time}, "Yes"))



Answers

  • Ric T
    Ric T ✭✭✭✭✭

    Hi @shiggins990,

    Try this formula out:

    =IFERROR(TODAY() - MAX(COLLECT({Incident Date.}, {Region}, "Warehouse", {GB Lost Time}, "Yes")), "N/A")

    Essentially the formula will return "N/A" when your formula results in an error. You can switch the value_if_error to "0" too if that floats your boat!

    Cheers,

    Ric

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!