Solved! I approached this a little differently. The URL for my destination and image aren't statically defined, rather they come from other locations within the sheet. =ArrayFormula(If(isblank($A2...
What if I want the link to be dynamic based off of another value in the row. I'm trying to use an if statement, but it isnt working.