Hi
I may have been a little presumptuous saying I have this working. I found a small issue in testing. The issue I am having is getting the [Duration] functionality working. As per above âif the [Duration] on [Job Card #] 000023 changed from 4hr to 5hr then that would change the finish time to 12.30 and update all subsequent [Start] & [Finish] times by 1HR.â [Finish] is currently a formula so that will update correctly based on the [Duration] & [Start] so actually no need to factor this in really.
-
I created a âSet the values of some columns in this rowâ and set [Duration] to [Duration]+â000:15:00â and [Start] to [Start]+â000:15:00â to increment in 15 min intervals.
-
My âOnly if this condition is trueâ expression needs to update the existing rowâs [Duration] & [Finish] and all subsequent [Start] & [Finish] values. Do I need to create an additional âSet the values of some columns in this rowâ action, group them and select that grouped action as the Reference action below?
The reason I ask is because I think I can only achieve my requirement with 2 different âOnly if this condition is trueâ expressions. One to increment the current rowâs duration and another to ignore the current rowâs [Start] but update all subsequent [Start]s.
I just canât seem to get those expressions right because what is happening is all [Duration]s are updating by 15 mins and none of the subsequent [Start] times are updating.
My âExecute an action on a set of rowsâ action is created with a Referenced Row expression
FILTER(âRoutings_Masterâ,
AND(
[Routing Date]=[_THISROW].[Routing Date],
[Department]=[_THISROW].[Department],
[Equipment / Area]=[_THISROW].[Equipment / Area]
))
Referenced action as per above.
My âOnly if this condition is trueâ expression is [Status]=âIn Productionâ
Could you maybe advise if I am on the right track and what expression(s) might help to achieve what I need?
Many thanks.
Maurice.