MAX NUMBER ON A NOTHER SHEET

12/31/20
Accepted

=IF({Equipment Service Log - Webform Range 2}, [email protected], MAX({Equipment Service Log - Webform Range 1}))


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

Best Answer

  • Leibel SLeibel S ✭✭✭✭
    Accepted Answer

    Your syntax was incorrect. See below fixed...

    =MAX(COLLECT({Equipment Inspection Log - Webform Range 3},{Equipment Service Log - Webform Range 2},[email protected]))

Answers

  • Leibel SLeibel S ✭✭✭✭

    @Samuel Dowdy Jr

    Try the below:

    =MAX(COLLECT({Equipment Service Log - Webform Range 1},{Equipment Service Log - Webform Range 2},[email protected]))

  • Samuel Dowdy JrSamuel Dowdy Jr ✭✭✭✭✭

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

  • Leibel SLeibel 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},[email protected]))

  • Samuel Dowdy JrSamuel Dowdy Jr ✭✭✭✭✭

    =MAX(COLLECT({Equipment Inspection Log - Webform Range 3}), {Equipment Inspection Log - Webform Range 2}, [email protected])


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

  • Samuel Dowdy JrSamuel Dowdy Jr ✭✭✭✭✭

    It says Incorrect argument

  • Leibel SLeibel S ✭✭✭✭
    Accepted Answer

    Your syntax was incorrect. See below fixed...

    =MAX(COLLECT({Equipment Inspection Log - Webform Range 3},{Equipment Service Log - Webform Range 2},[email protected]))

Sign In or Register to comment.