autofill of formulas is not working when adding more than one line of data without saving the sheet
I have a sheet with some formulas.
If I add a new row of data ,the formulas are autofilled as expected.
If I add another row of data, the formulas are not autofilled.
If I save the sheet after adding the first row of data, the next new row will autofill the formulas.
This means, I have to save the sheet after adding each row of new data to have the formulas autofilled, which is very uncomfortable and unexplainable to my colleagues.
How can I change this bevaviour for adding some lines of new data and have the autofill function working without saving the sheet after each row?
P.S. will happen in table view and card view
Help Article Resources
Check out the Formula Handbook template!