Max(Collect formula

krsch88 ✭✭✭

I'm trying to pull in the most recent date of a file, and it looks like =Max(Collect is the way to do it, but I'm having trouble with getting the formula to work.

Currently, I have

=MAX(COLLECT({Date of Recent Update}, {Parent Folder}, [Delivery Path]@row))

where Parent Folder and Delivery Path would be the reference to tie the two sheets/rows together.

As you can see in the 2nd screenshot, I'm getting an #INVALID COLUMN VALUE error, though the column is set to a Text/Number (I also tried it with a Date type, with the same error message)

In Excel, I'd use a MAXIFS, in case that helps. =MAXIFS(Date of Recent Update column, Parent Folder column, Delivery Path at row)

Any suggestions on making this formula work? Thanks!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!