Hi there,
I am fairly new to Smartsheets and wasn't best with excel but I'm slowly getting the handle of things. I had a question about the SUMIF formula. My company tracks data a little differently so I am having a hard time looking at examples and applying them to my situation.
Basically, I need to create a formula that helps me track the quantity (sum) of doors built in a certain month that fall under a certain "reason". The "reasons" are in their own column, as well as the quantity and the date. I was able to figure out how to find the total sum of the entire list of data, as well as the total sum of each 'reason' on their own, but now I am trying to get it to be a little more specific and this is where I am struggling. Formulas have never been my strong suit. I'm not quite sure what the order should be in the formula as far as: SUM, DATE, REASON.
Any help would be much appreciated! And if you need to me clarify more since this data is a little odd, please don't hesitate to ask. Thank you in advance!
