For better performances, I which to be able to insert formulas while using the insert row action.
I had this formula at first :
Which I changed into
so it works whatever line it is used, but when I put that in the “custom content” of the insert row, it inserts it with a
' just before so it’s rendered as text and not evaluated.
Any idea? I want to avoid relying on Google Scripts since it’s too slow to run for my users to see an instant change on the app.