CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulas
user1592380
user1592380

Reputation: 36277

Formula parse error with Sheets array literal

enter image description here

I'm trying to follow https://support.google.com/docs/answer/6208276 to put a column header in U3 with a formula in the cell below it. I have:

=ArrayFormula({'HI';  if(Today()-V4:V=today(),"no",Today()-V4:V);})

But I'm getting a 'Formula Parse error' . How can I fix this.

Upvotes: 1

Views: 160

Answers (1)

pnuts
pnuts

Reputation: 59475

Try:

=ArrayFormula({"HI";if(Today()-V4:V=today(),"no",Today()-V4:V)})

Upvotes: 1

Related Questions