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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!