SumIFs formula #INVALID DATA TYPE error

edited 12/09/19 in Formulas and Functions

Getting the #INVALID DATA TYPE error with this formula:

=SUMIFS({Forecasts (SS) Hours}, {Forecasts (SS) Consultant}, $[Consultant Name]23, {Forecasts (SS) Start}, WEEKNUMBER(@cell) = 48, {Forecasts (SS) Cancelled}, 0, {Forecasts (SS) Start}, YEAR(@cell) = 2019)

What's frustrating is if I change the ${Consultant Name]23 to a different number, say 24, it works. Also if I change the name in the column in cell 23 to something else, it works too. This particular name seems to be giving the error. This sheet references another sheet that contains the names of the Consultants, however, I can't find anything wrong with the name. I've tried deleting and re-adding the name to both sheets. 


Thank you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!