When Phases are Changed, Capture the Date:Workflow is not possible because the column contains links
We have created one more test case.
The sheet contains an AppliedPRO column in which these cells are linked to their respective individual projects. When the user changes the phase (Initiate, 1st DOE, 2nd DOE, Target Met), our source sheet (master sheet) will update, but I need a record date (capture the date) when the phases changed.
For instance, when the user changed the phase from "blank" to "Initiation". Then we must record the initiation changing date at that time.
Some of you will suggest Record date workflow, but that is not possible. Because cell linking columns will not trigger workflow.
We hope that this scenario is useful to our Smartsheet users.
Note: We are trying to post test cases so that will assist PMs when they encounter similar issues.
Thanks & Regards
Email ID: [email protected]
Did I answer to your question or fix the problem? Please
Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!
Help Article Resources
Check out the Formula Handbook template!