Max(Collect formula

Options
krsch88
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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!