Sumif Formula Question


I have a sheet containing a Time Block column as well as a Type column. Both are dropdown columns one with time in hours (.24, .5, .75, 1, 2 and so on), the other has types of activities (Dev Meeting, General Admin, and so on). I am trying to build a formula that adds the time for each activity by the month. I can't get past adding up the time by activity. Right now I am doing it in as part of the Sheet Summary. My formula is: =SUMIF(TimeBlock:TimeBlock, ={Dev Meeting}, Type:Type) I get a total of zero, indicating the formula is correct, but I know there are several entries of Dev Meeting types equaling several hours. Any help is appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!