Copying a value from one column to another when triggered
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
Check out the Formula Handbook template!