Referencing a not blank cell of 5 cells.

Jaret Alexander · 08/31/20

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 · 08/31/20

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 · 08/31/20

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 · 08/31/20

Fantastic. It worked. Thank you so much!

Paul Newcome · 09/01/20

Happy to help. 👍️

Referencing a not blank cell of 5 cells.

Best Answer

Answers

Help Article Resources

Categories