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

mfanti

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?

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.