Formula modification help.

I need to modify a formula to pull values of two different cells "SAP PROJECT NUMBER" and "JOB NUMBER" from another "Time Tracking" sheet. I make it work with pulling just one lookup but not two. Below is my formula for one - where to I add the [JOB Number] so it pulls both in this formula?


=SUMIFS({Time Tracking Range 4}, {Time Tracking Range 5}, [SAP Project Number]1383)

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hi Jennie

    Just to verify your formula, the {Time Tracking Range 4} should be the column you're trying to sum, like $ or time, for example.

    To help ensure that we're referring to the same range, I'll specifically call out the range by name.

    =SUMIFS({Time Tracking -the column you're summing}, {Time Tracking SAP Number}, @cell = [SAP Project Number]@row, {Time Tracking Job Number}, @cell=[Job Number]@row)

    Be sure to change the ranges in the formula to your real range names.

    If this doesn't work, let me know and we can re-work it.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!