Referencing a not blank cell of 5 cells.

Jaret Alexander

Hi,

I am trying to populate a cell with data in 1 of 5 cells that are filled from a form. For example, using form logic of the organization that is selected (column Org Name) select the site from that Org (Org 1 and site 1) Each Org has its own list of sites in its respective column.

I have tried using IF(ISBLANK(NOT( and can't seem to find the correct syntax. Wondering if this is even the correct function.

Any help would be much appreciated.

Thank you!

Paul Newcome

Try something like this:

=JOIN(COLLECT([First Column]@row:[Last Column]@row, [First Column]@row:[Last Column]@row, @cell <> ""), ", ")

If that doesn't work, a screenshot with sensitive/confidential data removed, blocked, and/or replaced with "mock data" as needed would be very helpful towards finding a solution that does work.

Paul Newcome

Try something like this:

=JOIN(COLLECT([First Column]@row:[Last Column]@row, [First Column]@row:[Last Column]@row, @cell <> ""), ", ")

If that doesn't work, a screenshot with sensitive/confidential data removed, blocked, and/or replaced with "mock data" as needed would be very helpful towards finding a solution that does work.

Jaret Alexander

Fantastic. It worked. Thank you so much!

Paul Newcome

Happy to help. 👍️