Index collect for latest project status

Hi,

I have 2 sheets. Sheet 1 has a form where users can submit their project status each week. So sheet 1 has multiple lines with updates from each week for each project. In sheet2, for each of the project, I only want to get the latest status update. I tried using Index(collect({Project Status}, {Project Name from sheet 1},{Project Name}@row, {Update Date}, max{Update Date}), 1)

But there is only one row for which the project name will match the latest update date. So only 1 project gets the status update. All others show as blank.

Thanks for your help.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!