I am trying to get a MAX Date:
=MAX({1.1 Invoices Date}, {PK#2}, [PK #]@row)
Is COLLECT required to make this work?
I also tried this:
=MAX(COLLECT({1.1 Invoices Date}, {PK#2, [PK #]@row}))
No luck.
Hey @Mike B
A COLLECT function has the syntax COLLECT(range to be collected, range1, criteria1, range2, criteria2, etc). The syntax of your formula above is not what smartsheet is expecting.
Try this.
=MAX(COLLECT({1.1 Invoices Date}, {PK#2}, [PK #]@row))
Does this work for you?
Kelly
I'm getting the error code: #INVALID COLUMN VALUE.
Hello @Mike B
Is your formula column formatted as a date column?
Yes, it is a date column.
Oops, It was actually formatted as a Text/number, I change it to a date column and it worked. WOW. Thanks!!!!
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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
