Automation to change cell value not working
I have SCC setup to provision projects.
Inside the project plan there is a variety of data coming from the intake sheet that will be used to determine what duration to pull from a separate master lead time sheet via INDEX/MATCH. The final lead times populate the Duration Planner column for every task.
In addition, there is a MigrationData column that checks if any additional parameters coming from the metadata sheet should be adjusted to completed or not by adding a C to rows in this column that should be changed to "completed".
I then want (ideally only at project provisioning) to use the Change Cell Value automation to update the task status field (single select drop down) based on any fields that have 0 in the Duration Planner or C in the MigrationData column.
No matter what i try i can not get it working. What am i missing and how can i make this work?
Things that i have tried:
- Triggered by ANY changes to DurationPlanner or MigrationData columns with the condition that it is a 0 or a C. - DOES NOT WORK
- Triggered by ANY changed to a "Trigger" column that is an inbound link to intake sheet. Requires additional step of changing the text in this intake sheet after a project is provisioned. - DOES NOT WORK
- Record A Date automation to add todays date to a "datetrigger" column every day at 8am (this part works), combined with a separate change cell value automation set to trigger by ANY changes to the datetrigger column. - DOES NOT WORK
- Used a "Final Duration" formula column to simply pull the values from Duration planner, and trigger from ANY changes to the Final Duration column. - DOES NOT WORK