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!
Best answer by Zack_S
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'
+17Hey 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'
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'
Thanks Zack - and I appreciate the helpful screenshots!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
