title: How can I return a string, "Empty", if an arrayFormula returns nothing?
body: <p>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...</p>
  <p>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.</p>
  <p>This information is then printed out in a dashboard like so:
  <a href="https://i.stack.imgur.com/Rm79E.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Rm79E.png" alt="enter image description here" /></a></p>
  <p>What I need to be able to do is print &quot;Open&quot; in a cell where there is no job found under that day (Th/F)</p>
  <p>I've tried using</p>
  <pre><code>=ARRAYFORMULA(IF(ISBLANK(...
  </code></pre>
  <p>but can't get it to work.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1-oT9nSYB-w1_bA3VZ7SZpAHcgh044dLiLzv90K4RHv8/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1-oT9nSYB-w1_bA3VZ7SZpAHcgh044dLiLzv90K4RHv8/edit?usp=sharing</a></p>