Finding the biggest date


Hello All,

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.



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!