Formula help

Options

I am needing to pull from the main sheet:

If contractor is X, and it is X date how many "daily weld count"

I need to put together a graph that shows contract X has # welds per day. I have managed to count how many entries there are for a given date but not the # in the "daily weld count" column.

Here is the formula I used so far

=COUNTIFS({Weld Count Log Range 1}, [Primary Column]@row, {Weld Count Log Range 2}, [Column7]@row, {Weld Count Log Range 4}, "Field Welds")


Jacque Smith

Project Controls, MSR-FSR

Tags:

Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @jacquedale


    You will need to change the formula to SUMIFS to get the total sum for your criteria. =SUMIFS([Daily Weld Count]:[Daily Weld Count], Contractor:Contractor, "Contractor name", Date:Date, "your date criteria", [Shop/Field Weld]:[Shop/Field Weld], "Field Welds")

    Thanks,

    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @jacquedale


    You will need to change the formula to SUMIFS to get the total sum for your criteria. =SUMIFS([Daily Weld Count]:[Daily Weld Count], Contractor:Contractor, "Contractor name", Date:Date, "your date criteria", [Shop/Field Weld]:[Shop/Field Weld], "Field Welds")

    Thanks,

    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • jacquedale
    jacquedale ✭✭✭✭✭
    Options

    @AravindGP You are a life saver! This worked perfectly. Thank you so much.


    Jacque Smith

    Project Controls, MSR-FSR

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!