Copying a value from one column to another when triggered

Hello -

I have a sheet that has a project start date column and an end date column. When the project is approved, I would like those dates to be copied into another column (as "start date" - "end date"), or if necessary, a two columns (one for each of the dates). Once the dates are copied, I do not want them to update further.

I assumed I could create a workflow rule that is triggered when the status goes to "approved" and use that to change a value when specified criteria are met. However, when the workflow rule runs, it places the formula in the column, but as text rather than the resulting value that I was hoping for.

I'm hoping to avoid using a secondary sheet for this and would like to keep everything contained on the one sheet. Is this possible?

Thanks, in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!