SUMIFS help in Summary with column headers containing special chars

I'm trying to get the below SUMIFS to work but i'm getting #UNPARSEABLE.

=SUMIFS(Requested Amount (in Local Currency):Requested Amount (in Local Currency), Budget Owner*:Budget Owner*, "Tom MacKay", Approved:Approved, = 1)

The column names contain special characters, is that what is causing the problem? Or do I just have the syntax all wrong?

Best Answer


  • Stefan it was perfect!!! Thanks so much!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!