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

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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