Sumifs - Cross sheet reference

AliT

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.

Julie Fortney

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!

Julie Fortney

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

Thank you!! That was the ticket!!!