Referencing a not blank cell of 5 cells.
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!
Best Answer
-
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.
Answers
-
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.
-
Fantastic. It worked. Thank you so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!