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) + " || ")
