Automation copying values from other cells

rbarlotti

Is there a way to create an Automation that when some criteria is satisfied (like status is In progress) and I update one field with the data from another field in the same row?

let me explain, I want to automate the % Completion bar progress with the actual % based on the time consuming at today's date. So every day, or when I run the automation, it will update the In progress % Completion field until it reaches 100%

SoS | Dan Palenchar

Hello @rbarlotti,

It sounds like you are asking if you can have one cell take on the value of another cell whenever a trigger condition is met. Specifically, I ascertain you have a % Complete column and an Actual % column and that you want % Complete to have the same value as Actual %.

If you are using Project Settings than % Complete cannot be automated in this fashion. If you are not, than you can use a formula to do this and set % Complete equal to Actual %.

I'm not sure I'm completely understanding your question though.