SUMIF FORMUAL WONT WORK IN COLUMN THAT IS CONVERTED TO A FORMULA

Options

I am trying to sum the net sales for the current month in my "Daily Sales Activity" sheet IF my helper column says "YES" (this is the current month) but I keep getting INVALID DATA TYPE.

My formula is =SUMIF([CURRENT MONTH HELPER 2]:[CURRENT MONTH HELPER 2], "YES", [Net Sales]:[Net Sales])

i think its because the rest of the column isn't filled out yet and says INVALID DATA TYPE but that wont be filled out until the days go on. How can I fix this?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!