MAX NUMBER ON A NOTHER SHEET
=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
Best Answer
-
Your syntax was incorrect. See below fixed...
=MAX(COLLECT({Equipment Inspection Log - Webform Range 3},{Equipment Service Log - Webform Range 2},Description@row))
Answers
-
Try the below:
=MAX(COLLECT({Equipment Service Log - Webform Range 1},{Equipment Service Log - Webform Range 2},Description@row))
-
Yes, what if I want to collect last inspection date?
-
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))
-
=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
-
It says Incorrect argument
-
Your syntax was incorrect. See below fixed...
=MAX(COLLECT({Equipment Inspection Log - Webform Range 3},{Equipment Service Log - Webform Range 2},Description@row))
Help Article Resources
Categories
Check out the Formula Handbook template!