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 (Current Month Sales)
The conditions below formulates when the "Sold Date" & "Result" = (100%) in the current month/year (January 2017) When Febuary rolls over the row that calulates ("Current Month Sales") will zero out.
I need a formula that captures all the sales for each month (January, Febuary, March....etc). Thinking a formula that calulates each month (Hide it maybe) Then set up a row from that, that calulates all the sales for the year. How do i continue from the formula below please? The master Craig W has been a massive help getting me this far.
=SUMIFS([Value of Jobs]2:[Value of Jobs]50, Result2:Result50, 1, [Sold Date]2:[Sold Date]50, MONTH(@cell) = MONTH(TODAY(), SUMIFS([Value of Jobs]2:[Value of Jobs]50, Result2:Result50, 1, [Sold Date]2:[Sold Date]50, YEAR(@cell) = YEAR(TODAY()))))