-1

I am trying to automatically copy formulas into a range of cell but whenever I try adding a new line it deletes the formula and I have to copy it again. I am trying to eliminate this. Is there a script that will allow this or anything similar?

Here is the formula: =IF(E2=0,IF(D2>0,"not done",""),"")

Thanks

TimSPQR
  • 2,964
  • 3
  • 20
  • 29
aku181
  • 17
  • 1
  • 3

1 Answers1

0

Try wrapping it in an arrayformula, like this:

=ArrayFormula(IF(E2:E=0,IF(D2:D>0,"not done",""),""))

That'll extend when new rows are added.

Cilan
  • 13,101
  • 3
  • 34
  • 51
JPV
  • 26,499
  • 4
  • 33
  • 48