Sumifs - Cross sheet reference

HI,

I am very new to smartsheet, but trying to build a rollup sheet from a source sheet. I need to pull the $ amount for every "Executed" contract.

I've tried the below formula and

SUMIFS({Sheet - Contract Management - Complete Lib Range 2},Contract Amount/NTE:Contract Amount/NTE,Status:Status, "Executed")

SUMIFS({Sheet - Contract Management - Complete Lib Range 2},[Contract Amount/NTE]:[Contract Amount/NTE],Status:Status, "Executed")

I am getting UNPARSEABLE

Any help will be appreciated.

Best Answer

  • Julie Fortney
    Julie Fortney Overachievers
    Answer ✓

    Are there multiple criteria you are evaluating the contracts for, or is the only criterion that it be Executed?

    If you only have one criterion, try a SUMIF formula instead.

    SUMIF({Sheet - Contract Management - Complete Lib Status Column}, "Executed", {Sheet - Contract Management - Complete Lib Contract Amount/NTE Column})

    In narrative form, we are summing the Contract Amount/NTE column on the Contract Management... sheet for all rows with "Executed" in the Status column.

    I hope that helps!

Answers

  • Julie Fortney
    Julie Fortney Overachievers
    Answer ✓

    Are there multiple criteria you are evaluating the contracts for, or is the only criterion that it be Executed?

    If you only have one criterion, try a SUMIF formula instead.

    SUMIF({Sheet - Contract Management - Complete Lib Status Column}, "Executed", {Sheet - Contract Management - Complete Lib Contract Amount/NTE Column})

    In narrative form, we are summing the Contract Amount/NTE column on the Contract Management... sheet for all rows with "Executed" in the Status column.

    I hope that helps!

  • AliT
    AliT ✭✭

    Thank you!! That was the ticket!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!