How Do I Capture The Most Recent Date From One Sheet Onto Another Sheet?

I am trying to pull the most recent date for a specific project into a cell on another sheet and have it update automatically when a new/most recent date is put in.

Ie. The 10/27/23 date is pulled to a master sheet and updates automatically when a more recent date is put in.

I used this formula, but it didn't work.

=MAX(COLLECT({Date}, {Project Name}, 5001 - Migration to OCI))

Sheet 1:

I went to my Sheet 1 and pulled the Date column first, then the Project Name column. I also changed the Column Type to Date on my Sheet 2.

Sheet 2:

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!