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
-
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
-
Hi Jason. I thought that would be the case. I will give this a go and let you know.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!