MAX Date help

Mike B

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.

Kelly Moore

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

Mike B

I'm getting the error code: #INVALID COLUMN VALUE.

=MAX(COLLECT({1.1 Invoices Date}, {PK#2}, [PK #]@row))

Kelly Moore

Hello @Mike B

Is your formula column formatted as a date column?

Kelly

Mike B

Yes, it is a date column.

Mike B

Oops, It was actually formatted as a Text/number, I change it to a date column and it worked. WOW. Thanks!!!!