Join Collect from Other Sheet only IF not blank
I'm looking to collect all project updates in a single cell with a running history. The information lives in separate lines in a sheet:
Current Formula:
=JOIN(COLLECT({Timestamp + Note}, {RowID}, [Project ID]@row), CHAR(10) + " || ")
Update needed: "SKIP" rows where the Timestamp + note is blank.
I tried adding a criterion for not(isblank) but was unable to do it successfully.
What do I need to add to this?
=JOIN(COLLECT({Timestamp + Note}, {RowID}, [Project ID]@row), CHAR(10) + " || ")
Answers
-
Hi! to add the criterion for skipping blank cells, you can reference that criterion range ({Timestamp + Note}, I assume), and use the criteria <>"" — in other words, something other than blank.
=JOIN(COLLECT({Timestamp + Note}, {RowID}, [Project ID]@row), {Timestamp + Note}, <>""
(I'm guessing there's a way to use the Not(isblank) here instead, but honestly i get confused about the syntax when combining that in with other things! :>)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!