Looking for the most recent date - across several sheets

Hi all,

This formula works perfectly when referring to 1 sheet -

=MAX(COLLECT({Competencies Awarded Range 1}, {Competencies Awarded Range 2}, "Bob Jones"))

The forumla is to find the latest date that a internal learning unit was submitted.

However due to the number of internal units it has been decided to split the sheet up into several sheets. So now I need to find the last date a unit was submitted across several sheets. is this possible?

Clumsy work around would be to create a collation sheet (use the above formula for each sheet into 1 sheet) and then refer to that but ideally the formula would be smart enough!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!