mercredi 20 mai 2020

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!

Aucun commentaire:

Enregistrer un commentaire