Using max collect to pull the most recent entry per project

Laura Briggs
Laura Briggs ✭✭
edited 08/17/22 in Formulas and Functions

Im looking for some help please?

Ive created a smartsheet that allows PM's to enter their project status reports using a form. To create a dashboard of the most recent updates, Ive created a further sheet and have been trying to use =MAX(COLLECT to pull the most recent entry of each project through to the master sheet using the formula below:

=MAX(COLLECT({Project Status reporting Range 1}, {Project Status reporting Range 2}, [Project Name]1))

Im not getting an error message however there is no information pulling through despite there being a umber of entries into the database sheet?

Does anyone have any suggestions as to what im doing wrong?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!