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:
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.