I have exhausted google and the community page and can’t seem to find something I was expecting to be quite common.
I have a “Project Overview” and a “Project Details” board. Overview shows the project workflow at a glance with key milestones while to details show every step with scheduled dates for each step, along with the selected milestones mirrored to the overview board.
I’m looking to add a date column to the overview board of the next scheduled day in the workflow so again, at a glance I can see “Project ABC has Stage 5 completed so therefor Stage 6 is scheduled for DATE”
I thought adding a formula Column to the details board and mirroring it across , surely there is a formula to show closest future date to todays date
Interested to know peoples thoughts or work arounds
Below is my Details Board" with a lot more info, status columns and date columns. This feeds the overview board the key milestones. Project workflow progresses left to right.
What I’m looking to achieve is have a date column on the overview board that is the next date a project has something scheduled in.
For example, project at Lot 205, 41 Madeleine Drive has “Finish Off” scheduled for June 30, while the Date column for Lot 209 would display a missed dead line of June 9.
If you need the Next Date to be an actual date column, I would recommend using an Integromat scenario called with a webhook when any column changes on the details board.