CODEWITHSUNDEEP
if-statementgoogle-sheetsarray-formulas
Ryan Millar
Ryan Millar

Reputation: 1

Having issues with Google Sheets formula combing ArrayFormula with IF

This works the way I want it to but I want to use the ArrayFormula to add the formula to the whole column starting at Cell J2:

=IF(E2:E="Closed","",MINUS(TODAY(),I2))

This doesn't work:

=ARRAYFORMULA(IF(E2:E="Closed","",,J2:J), MINUS(TODAY(),I2))

I have tried multiple ways to add the ArrayFormula into it and reorganized it multiple ways but it failed.

Any ideas where I am going wrong?

Any help appreciated!

Upvotes: 0

Views: 48

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

Please use the following formula 

=ArrayFormula(IF(I2:I<>"", IF(E2:E="Closed","CL",MINUS(TODAY(),I2:I)),""))

(where today is May 20th. Adjust ranges and notifications to your liking)

enter image description here

Upvotes: 1

Related Questions