Forum Discussion
Blank cell until other cells are populated.
Hello everyone. I was wondering if someone could help me. I’m trying to populate a cell D23, I would hope to keep it BLANK, until any of the cells in column D are populated. Each D cell is desig...
Not sure what you need, but what about this formula in D23:
=FILTER(D5:D20,LEN(D5:D20)>0)
=FILTER(D5:D20,LEN(D5:D20)>0)
I will try this one out.
I got one that seemed to work=TEXTJOIN("; ", TRUE, D5,D8,D11,D14,D17,D20) worked perfect, shoutout to SnowMan55.
The date drives the process, my only fear is my boss wanting to use overlapping dates of those process in Column D, but for now this helps isolating a date and knowing which process we need to review because each process has restrictions I will place on another tab as a dashboard.