Invalid Column Value On Dashboard

shiggins990

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"))

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