Hi - I have a dataset structured like the table below where I have products that need to go through a set of processes with various cycle times. I'm looking to create a multi-row formula/tool that groups by the Product and gives the LatestStartTime for each process, working back from the EndDate and the prior process. In the "LatestStartTime" I show the desired output.
| Product | Process | EndDate | HoursInProcess | LatestStartTime (DESIRED OUTPUT) |
| ProductA | Process1 | 1/31/2023 | 48 | 1/26/2023 |
| ProductA | Process2 | 1/31/2023 | 48 | 1/28/2023 |
| ProductA | Process3 | 1/31/2023 | 24 | 1/30/2023 |
| ProductB | Process1 | 1/31/2023 | 24 | 1/22/2023 |
| ProductB | Process2 | 1/31/2023 | 24 | 1/24/2023 |
| ProductB | Process3 | 1/31/2023 | 24 | 1/26/2023 |
| ProductB | Process4 | 1/31/2023 | 72 | 1/28/2023 |
Thanks for any advice/input here!
