Finding the biggest date
Have no clue on how to approach this. I have 2 smartsheets as follows:
- Main SmartSheet: List of main projects and associated ID number.
- Sub SmartSheet: List of sub projects linked to the main project through the ID number with status and due dates. Hence I have multiple sub-project for each project with due dates.
I need to display the number of subproject still active --> done.
But I also need to show the latest due date of all sub projects for one main project.
Hence I need to look up (INDEX/MARC) all sub projects linked to the main project and then run a MAX function on the due dates.
No clue how to set the order. I assume INDEX, MATCH and MAX, but how to combine?
Hope someone can help.
Help Article Resources
Check out the Formula Handbook template!