Can i use collect function on images?

I have a an image pasted over a cell and when i use Index collect, it seems to copy the image but i only get "image.png" in bold and no displayed image…

Any ideas how to fix this? Here is my formula:

=IFERROR(INDEX(COLLECT(Photo1:Photo9, Department1:Department9, =Department11), 1), "")

Find more posts tagged with

Accepted answers

Paul Newcome

We currently are not able to use formulas to pull in images like this. You will need to get creative using a report or cell linking or potentially building something out using the API, but unfortunately formulas just don't work.

All comments

jjg279

Hey Brandon, Smartsheet doesn't support having more than 1 image in a cell, is there only one in each range you are collecting?

Brandon Morales

No, only one image. heres a screenshot

Paul Newcome

Brandon Morales

ok, that makes sense then. thanks Paul.

Paul Newcome

Happy to help. 👍️

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.