SUMIFS

toby45106

toby45106 ✭✭

05/08/18 edited 12/09/19 in Smartsheet Basics

I keep getting an error when I try this formula. I basically want to Add Contract Amount if the YR = 18 and the MO <4.

Any suggestions?

0 ·

Comments

Chris McKay ✭✭✭✭✭✭

05/08/18

Hi Shirley,

Something like this perhaps:

=SUM(COLLECT([Contract Amount]:[Contract Amount], [Contract Date]:[Contract Date], YEAR(@cell) = 2018, [Contract Date]:[Contract Date], MONTH(@cell) < 4))

Kind regards,

Chris McKay

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Is it possible to have a multiple line entry using a form?
This could be far-fetched, but is there any way to set up a form to where you can fill it out like this screenshot below? Where it is more than 1 line entry without having to enter 100 different submissions? Currently people email me this excel every week and I have to copy and paste it into a different excel sheet.…
Create Folder under Sheets Tab
I have several folders under my Sheets tab that I created in the past. Today I'm trying to create a new folder there and cannot do it. I can create a folder in a workspace, but not under my Sheets tab. Right clicking on "Sheets" shows a create option but no folder option anywhere to be found. Right click in a blank area of…
Conditional formatting - OR condition?
I need to use conditional formatting to specify an OR condition on multiple columns. I only see the AND condition option. Without an OR condition, I have to create multiple conditional formatting rules. Is there any way to get an OR option for the conditional formatting? Why would there be just an AND option and not an OR…

Help shape the future of Smartsheet.
Share your ideas and feature requests.