Need the latest date for a resource to pull to another sheet

Brad Renaud
Brad Renaud ✭✭
edited 05/30/23 in Formulas and Functions

I am trying to pull the latest scheduled date for my machine resources from my scheduling sheet to my lead times sheet.

I am using this formula but getting Incorrect Argument Set;

=MAX(COLLECT({Fabco Schedule Range 2}, {Fabco Schedule Range 1}, "Shear"))

I want the Assigned To Column to be the basis and the latest Finish Date

Thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!