How do I add another word to filter this formula

I would like this formula to pull "WIP" jobs and "Offsite work". how do i add this

=SUM(SUMIFS({Dates}, {departments}, "Fabrication", {status}, "WIP")) * 1.25

Best Answer

  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭
    Answer ✓

    Here is how I would write what I think you may be looking for:

    • =SUM(SUMIFS({Dates}, {departments}, "Fabrication", {status}, "WIP"), SUMIFS({Dates}, {departments}, "Fabrication", {status}, "Offsite work")) * 1.25

    I hope this helps!


    Zach Hall

    Training Delivery Manager / Charter Communications


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!