Helper columns to allow parent row data to be included in automation
I am trying to work on refining our automation in a project management tracker we have. Our parent row has the start and end date for the entire project. I am trying to create a helper column that would automatically count days to end of project for each project and repeat that number for each line of a project to simplify automation. That way when sending out automation it would say, "such and such process has been completed and we are # days away from the end of this project."
I am hoping to make it an automatic calculation that doesn't need to be regularly managed that way the automation applies every time a new project is added to the sheet.
Below is a snapshot of the sheet. The "End" date associated with the Project Name is the date I would be using to calculate the "Days to STR"