Rollup formula referencing different column?

[AlexW-DP]

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!

[Zack_S · Accepted solution]

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'

[AlexW-DP]

Thanks Zack - and I appreciate the helpful screenshots!