Home > Net >  How can I return a string, "Empty", if an arrayFormula returns nothing?
How can I return a string, "Empty", if an arrayFormula returns nothing?

Time:04-27

I must admit I am god awful with these formulas. I originally got this formula from someone else on SO, but I still can't get it to return my own string if the arrayFormula returns an empty cell...

This formula is searching for a Photographer's name in the first Filter function, and then the Job Name that the photographer is assigned to in the second Filter function.

This information is then printed out in a dashboard like so: enter image description here

What I need to be able to do is print "Open" in a cell where there is no job found under that day (Th/F)

I've tried using

=ARRAYFORMULA(IF(ISBLANK(...

but can't get it to work.

enter image description here

  • Related