Properly using Max(collect)

PM Assist
PM Assist
edited 07/27/21 in Formulas and Functions

I am trying to get Column37 to output the value in the "Is the employee currently off" column.

I don't understand why this is not finding a match.

I have done this exact same thing in another sheet and it works perfectly but for some reason, this is not matching

Here is the other one, which works for some reason.

Best Answer

  • PM Assist
    PM Assist
    Answer ✓


    Somehow I solved it by adding and referencing a worker column that was =IF([is the employee currently off?]@row = 1, 2, 1).

    I still don't understand why this change worked - would you be able to help me understand this Paul?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!