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

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!