Formula to Create a List of Non-Filled Cells in a Row (ignoring the first column)?

Hi,

I have a sheet that lists a bunch of documents in the primary column. The additional columns list out the names of people who either get access to those documents, or don't. The corresponding cells are filled in with green or left blank depending on their access.

I am trying to create a formula that will spit out a list of the people (column names) who do not have access to the document (non-filled cells). I have attached an image of what I am looking for. Any recommendations?

Find more posts tagged with

Formulas

Accepted answers

All comments

Joseph Aloysias - vSaaS Global

Smartsheet does not have a built-in function to dynamically return a list of column names where a row has blank cells. However, you can use a helper column with a formula to generate a comma-separated list of users who do not have access.

Formula for people who don’t have access

=JOIN(IF(ISBLANK([Allison]@row), "Allison", "") + IF(ISBLANK([Bob]@row), ", Bob", "") + IF(ISBLANK([Carrie]@row), " , Carrie", ""), "")

Keep adding the same formula for other columns.

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.