Max(Collect formula

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!

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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

😀

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.