Script to clear a range but keep formulas - Gsheets

Question

Specifically, I need a script to help me clear values from multiple rows but without clearing the formulas on those rows.

I have tried .clearContent which seems to just clear the whole row altogether without any option to keep the formulas.

I know that there might be some add-on that could help on a single sheet but I need to apply the procedure on multiple sheets so I would like to use a script for it.

Thanks!

Answer 1

Use range.getFormulas() to store your formulas, then call range.clearContent(), finally paste the formulas back with range.setFormulas().