Is there a way to show a particular image in a dashboard depending on which option is selected?

Hi Everyone,

I am creating a dashboard that will show which locations are open so the senior managers can quickly check in the morning.

It is simple enough and will show on the Dashboard that the location is open or closed through a Metric.

I want it to look a bit better so have included a picture of the locations as in the image below.

I would love it if when the location was closed that the image would be black and white and when open then it is in colour.

I have tried this by putting the images in the sheet itself and then a third column with this formula →

=IF([Open or Closed]@row = "open", [Image Open]@row, IF([Open or Closed]@row = "closed", [Image Closed]@row, ""))

that will select the correct image but it only brings over the Alt Text.

Does anyone think they know a way this could work please? It would just make the Dashboard perfect.

Answers

  • Jason Tarpinian
    Jason Tarpinian Community Champion

    You can't return physical images through a formula. The best workaround I could think of would be to create a sheet with your logic built into a checkbox (IF open, true, else false), with a corresponding image in another column. Then build a report that filters to if checkbox = true, show "Image" column and then embed that report into the dashboard.

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

  • Simon Bamford
    Simon Bamford ✭✭✭✭

    Hi Jason. I thought that would be the case. I will give this a go and let you know.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!