MAX NUMBER ON A NOTHER SHEET

Samuel Dowdy Jr.

=IF({Equipment Service Log - Webform Range 2}, Description@row, MAX({Equipment Service Log - Webform Range 1}))

Trying to get the max number from another sheet if the description is matching

Leibel S

Your syntax was incorrect. See below fixed...

=MAX(COLLECT({Equipment Inspection Log - Webform Range 3},{Equipment Service Log - Webform Range 2},Description@row))

Leibel S

@Samuel Dowdy Jr

Try the below:

=MAX(COLLECT({Equipment Service Log - Webform Range 1},{Equipment Service Log - Webform Range 2},Description@row))

Samuel Dowdy Jr.

Yes, what if I want to collect last inspection date?

Leibel S

Same formula, just change the range to the range with the inspection dates:

=MAX(COLLECT({Equipment Service Log - inspection date range},{Equipment Service Log - Webform Range 2},Description@row))

Samuel Dowdy Jr.

=MAX(COLLECT({Equipment Inspection Log - Webform Range 3}), {Equipment Inspection Log - Webform Range 2}, Description@row)

I did and it didnt work. I have the column set to date instead of text

Samuel Dowdy Jr.

It says Incorrect argument

Leibel S

Your syntax was incorrect. See below fixed...

=MAX(COLLECT({Equipment Inspection Log - Webform Range 3},{Equipment Service Log - Webform Range 2},Description@row))