Bring back value based on a value in another cell

hello all,

I have a formula that brings back a list of names in another sheet if in the current sheet cells with the respective column names are "Yes". Originally, I wanted to bring back column headers and since it is not possible in Smartsheet, I created a helper sheet reflected the names in the order I want and then in the current sheet said if a cell in the current sheet under column header X is yes then bring that value back. now I need to change it to ask it to bring the value if in the cell there is anything but No. any thoughts?

=JOIN(COLLECT({Special Care Items}, camp@row:Fleet@row, @cell = "Yes"), ", ")

Find more posts tagged with

Accepted answers

All comments

mahmadi

P.S. I have tried @cell <> "No , but it only works for words other than No but not for numbers

Genevieve P.

Hey @mahmadi

Using <> "No" is exactly what I would have suggested:

=JOIN(COLLECT({Special Care Items}, camp@row:Fleet@row, @cell <> "No"), ", ")

If this isn't working, can you post a screen capture of how the reference sheet is set up?

Thanks,

Genevieve

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.