#UNPARSEABLE ERROR MESSAGE
Is anybody able to advise as to why I am getting an error message using my formula:
=SUMIFS({Business Unit}, [Business Unit]@row, {Plane Travel Distance}, AND, ({Date of Upload}, @cell >= DATE(2024, 1, 1), {Date of Upload}, @cell <=DATE(2024, 12, 31)))
Thanks!
Best Answer
-
Sorry about that. I saw the issue with the AND syntax and missed the syntax issue before that:
=SUMIFS({Plane Travel Distance}, {Business Unit}, [Business Unit]@row, {Date of Upload}, AND(@cell >= DATE(2024, 1, 1), @cell <=DATE(2024, 12, 31)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Hey @JConno,
Looks like you need to remove the comma after the AND word:
=SUMIFS({Business Unit}, [Business Unit]@row, {Plane Travel Distance}, AND({Date of Upload}, @cell >= DATE(2024, 1, 1), {Date of Upload}, @cell <=DATE(2024, 12, 31)))
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Hi @bisaacs ,
I have used the formula you suggested and I am seeing INCORRECT ARGUMENT SET…
Any ideas?
Thanks!
-
The syntax is a bit off. Try this instead:
=SUMIFS({Business Unit}, [Business Unit]@row, {Plane Travel Distance}, {Date of Upload}, AND(@cell >= DATE(2024, 1, 1), @cell <=DATE(2024, 12, 31)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you for coming in to support!
I still have an error message as above.
I am trying to calculate from a master sheet the amount of KMs travelled by a particular business unit between 1st January 2024 and 31st December 2024.
Any thoughts?
Thanks!
-
Sorry about that. I saw the issue with the AND syntax and missed the syntax issue before that:
=SUMIFS({Plane Travel Distance}, {Business Unit}, [Business Unit]@row, {Date of Upload}, AND(@cell >= DATE(2024, 1, 1), @cell <=DATE(2024, 12, 31)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks @Paul Newcome !!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!