Hello,
I created an automation so that my Status column automatically changes when my % Complete column changes. Basically, the automations are the following:
If % Complete = 0% then Status = Not Started
If % Complete > 1% and <99% then Status = In Progress
If % Complete = 100% then Status = Complete
My automation runs fine one time and then becomes invalid. This is the error message I am getting: "This workflow triggered itself directly or through another workflow. Please modify the workflow so it doesn't cause an infinite loop."
Is there anything wrong with my automation? Please help me find a way to fix this issue. Thanks a lot!