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!

jmyzk_cloudsmart_jp

I have tested your formula

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

and it is working with my sheets. 😀

Please take a look at the dashboard below.

https://app.smartsheet.com/b/publish?EQBCT=223879b7714a4eeb8ae508fc4e4871c0

jmyzk_cloudsmart_jp

I have tested your formula

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

and it is working with my sheets. 😀

Please take a look at the dashboard below.

https://app.smartsheet.com/b/publish?EQBCT=223879b7714a4eeb8ae508fc4e4871c0

krsch88

Interesting. No idea why it wasn't working before. I messed around a bit with the reference names and column names, and now it is working... thanks also for sharing your dashboard! That gives me a great idea for organizing this project a bit better :)

jmyzk_cloudsmart_jp

😀