Clearing a smartsheet without losing the formulas.

Yvette Wilkins
Yvette Wilkins ✭✭
in Smartsheet Basics

Hello,


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


Yvette

· Share on FacebookShare on Twitter

Answers

  • Matt Johnson
    Matt Johnson Community Champion

    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.

    column formula.JPG

    I hope that helps.

    Matt Johnson

    DigitalRadius

    Smartsheet Platinum Partner

    · Share on FacebookShare on Twitter

Categories

woman with hands out and open

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video<