Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SUMIFS...Its working but when i add.......
Formula below works....
but when i add (In Bold) (Sales Stage is a drop list row with "WON" in it) It dosent like it ???
=SUMIFS([Value of Jobs]2:[Value of Jobs]5,[Sales Stage]2:[Sales Stage]5,"WON", Result2:Result5, 1, [Sold Date]2:[Sold Date]5, MONTH(@cell) = MONTH(TODAY()), [Sold Date]2:[Sold Date]5, YEAR(@cell) = YEAR(TODAY()))