Clearing a smartsheet without losing the formulas.


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



  • Matt Johnson
    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.

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner