Return task name associated with a future date
I have a project with linked tasks. I can get the start date of the next task using the following formula:
=MIN(COLLECT(Start2:Start6, Start2:Start6, >TODAY()))
How can I return the task name associated with this upcoming task?
In this example, this formula gives the next start date as 6/19/19. What formula will return ‘Task 3’?
Thanks. I’ve learned a lot from this community
Help Article Resources
Check out the Formula Handbook template!