Max Collect formula


HI All ,

I have a sheet that I am using a MAX(COLLECT formula,

I need to add to the formula

=MAX(COLLECT({date}, {team}, Name@row)) I need to add another column before the name row that will give the name of the person reporting the audit

So I am collection the last date of a field audit for Team member done by Auditor

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!