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
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!