Formular Stripped from cell when the row moved into different sheet

JinwonK · 03/21/25

Hello, I use simple formular to assign Due date =WORKDAY (Start Date, #of days) to add. I love it- Simply Works! Attached image.

Now, when this row met workflow automation criteria, and then move into different sheet as completed, the formular no longer display. Only show Due date value.

It this stripping formula normal? I just want to understand so I know what to expect.

Thank you, Jinwon

Melissa Yamada · 03/22/25

Hello @JinwonK

When moving rows in Smartsheet, formulas are not preserved; the moved rows will contain the static values that resulted from the formulas, not the formulas themselves.

If you need to maintain the formulas, you can copy the formulas from the source sheet and paste them into the destination sheet, ensuring the formulas are correctly referencing the new sheet's cells.

Melissa Yamada · 03/22/25

Hello @JinwonK

When moving rows in Smartsheet, formulas are not preserved; the moved rows will contain the static values that resulted from the formulas, not the formulas themselves.

If you need to maintain the formulas, you can copy the formulas from the source sheet and paste them into the destination sheet, ensuring the formulas are correctly referencing the new sheet's cells.

JinwonK · 03/24/25

Thanks, Milissa, Good to know.

Formulas and Functions

Formulas and Functions

Formular Stripped from cell when the row moved into different sheet

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula Help: Multiple if conditions

Removing a Formula

Is There A Way To Set A Character Limit?