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.

Find more posts tagged with

Formulas

Dashboards

Images

Accepted answers

All comments

Jason Tarpinian

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.

Simon Bamford

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.