Automation Work Flow
Hello Smartsheet Community,
I've implemented an automation where changing the End Date field automatically sets the Status to "Completed" and updates % Complete to "100%."
Here's the issue: When I update the End Date for line 42, it correctly updates the status to Completed and % Complete to 100%. However, line 41, which is its parent line, also has its End Date updated. This, in turn, marks the parent line as Completed, even though there are several child items under it that are still In Progress.
I'm looking for a solution to this problem. Is there a way to ensure that the parent line's status accurately reflects the status of its child items? Your assistance is much appreciated. Thanks!"