Max(Collect()) To pull in the most recent entry

Options
kaia2001
kaia2001 ✭✭
edited 10/17/22 in Formulas and Functions

Hi!

I am attempting to use MAX(COLLECT()) to pull in the most recent entry from a manually maintain status log. If the date in "Week off" column on the log is the most recent date and the Project name matches the name on the row in the "Data Sheet" then I want to populate the entries in the "Weekly Highlight" column.

Status Log:

Data Sheet:

=IF(AND({GSC | Project Status-Week Off} = MAX({GSC | Project Status-Week Off}:{GSC | Project Status-Week Off}),{GSC | Project Status-Project}=[Project Name]@row), {GSC | Project Status Range-Weekly Highlight},"")

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!