Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 07, 2023 08:02 AM
Hello,
I am looking to create a rollup field to display the next task due for a project. What I would like to do is have the rollup field display the task name, but the formula should reference something like the MIN({due date}) in order to select which of the many tasks are due next? Can't seem to make it work and am wondering if it's possible or if I'm going about it wrong?
Thanks!
Solved! Go to Solution.
Sep 07, 2023 12:07 PM
Hey there,
In your projects table rollup the due date field using the formula min(values). Use the filter option within the rollup to filter out completed tasks.
In Tasks table do a lookup of the due date rollup field
Also, in your tasks table use a formula that looks if the due date is equal to the rollup field and if it does, display the task name.
Finally, in your projects table, do a lookup of the calculation which I labelled 'next task'
Sep 07, 2023 12:07 PM
Hey there,
In your projects table rollup the due date field using the formula min(values). Use the filter option within the rollup to filter out completed tasks.
In Tasks table do a lookup of the due date rollup field
Also, in your tasks table use a formula that looks if the due date is equal to the rollup field and if it does, display the task name.
Finally, in your projects table, do a lookup of the calculation which I labelled 'next task'
Sep 11, 2023 06:08 AM - edited Sep 11, 2023 06:08 AM
Thanks Zack - and I appreciate the helpful screenshots!