Formular Stripped from cell when the row moved into different sheet

JinwonK

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

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.