MAX/IF function

Hello all,

I am trying to use the MAX/IF logic in smartsheet. It worked for me in excel:

I used the same logic from above in smartsheet:

And I get this:


Any ideas? Appreciate your help in advance. Thanks!

Best Answer

  • Jen Lange
    Jen Lange ✭✭✭✭✭
    Answer ✓

    Without knowing your sheet to confirm, I think this is the result you're looking for...

    =MAX(COLLECT([Column3]1:[Column3]10, [Column2]1:[Column2]10, [Primary Column]@row))

    In which case, replace your original formula with this one...

    =MAX(COLLECT({Employee Comp by Division and Specialty te Range 3}, {Employee Comp by Division and Specialty te Range 1}, [Primary Column]@row))

    Let me know if this works for you.

    -Jen

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!