Clearing a smartsheet without losing the formulas.

Yvette Wilkins

Hello,

Is there a way to clear a smartsheet without losing the formulas?

Yvette

Matt Johnson

Hi @Yvette Wilkins

If the formula is the same throughout the entire column you can use column formulas. Right click on the formula and click "Convert to Column Formula" at the bottom of the pop-up menu. It will override any other formula or data you have in that column though. Then you can clear the sheet and the formula will stay.

I hope that helps.