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
-
Hello,
using special characters in the column titles is not a good idea.
Anyway, what you are missing is, that column titles in formulas always need to have square brackets around them, if they do not consist of one word.
So try:
=SUMIFS([Requested Amount (in Local Currency)]:[Requested Amount (in Local Currency)], [Budget Owner*]:[Budget Owner*], "Tom MacKay", Approved:Approved, = 1)
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Answers
-
Hello,
using special characters in the column titles is not a good idea.
Anyway, what you are missing is, that column titles in formulas always need to have square brackets around them, if they do not consist of one word.
So try:
=SUMIFS([Requested Amount (in Local Currency)]:[Requested Amount (in Local Currency)], [Budget Owner*]:[Budget Owner*], "Tom MacKay", Approved:Approved, = 1)
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Stefan it was perfect!!! Thanks so much!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!