How to make multi-select selections be clickable links (in a report or dashboard)
Is it possible to add hyperlinks to each option in a multi-select column? For me this is less important in a Sheet than in a Report (or Dashboard), but I presume this would need to be set up in a Sheet for it to flow to a Report or Dashboard.
To elaborate, I'd like a Report to have each selected item in a multi-select column be a link to another document. I don't actually care if the items in the Sheet are clickable, but when generating and publishing a Report, I would like the items to be clickable.
Ideally this would be as easy as adding links to the items in the multi-select column properties' Values -- i.e., highlight each line, hit ctrl-k, add URL, done. This does not currently appear to be possible.
I imagine, though, that this would take some formula wizardry... Perhaps:
- Add a column that would concatenate the selected multi-select column's values (is this possible?),
- Add a URL to each of them (is this possible? I don't see any URL() or LINK() or HYPERLINK() functions)...
- ...based on an IF() function to apply the correct URL depending on which multi-select item was selected.
Is this possible? If so, any suggestions?
Help Article Resources
Check out the Formula Handbook template!