-
Re: JOIN only if cell is not blank
Thank you both! Thanks Paul, I also didn't think of using the COLLECT function. I used your formula, except changed ' NOT(ISBLANK(@cell)) ' to ' <> "" ' Works great. Thank you!1 · -
How can I convert a date to plain text?
I would like to be able to use a formula to generate a date in a text field. However, when I try the formula, for example =TODAY() + 1 I get the error #INVALID COLUMN VALUE Is there a way I can conve…1 ·