#INCORRECT ARGUMENT SET
I've been using this formula for a couple of years on several sheets.
=IF([Current Month]@row = "1", January@row, IF([Current Month]@row = "2", February@row, IF([Current Month]@row = "3", March@row, IF([Current Month]@row = "4", April@row, IF([Current Month]@row = "5", May@row, IF([Current Month]@row = "6", June@row, [Current Month]@row = "7", July@row, IF([Current Month]@row = "8", August@row, IF([Current Month]@row = "9", September@row, IF([Current Month]@row = "10", October@row, IF([Current Month]@row = "11", November@row, IF([Current Month]@row = "12", December@row)))))))))))
Not pretty I know, but it works. I've just returned from 2 week leave and discovered all of these formulas have fallen over, returning "#INCORRECT ARGUMENT SET" Nobody has touched the formulas or the sheets.
Anybody know what's happened?
Answers
-
Hi @S.I.D.
Looks like you are missing an IF( for your July If statement.
best,
Brad
www.MVPOPS.com
-
Hi @S.I.D.
I hope you're well and safe!
Try something like this.
= IF([Current Month]@row = 1, January@row, IF([Current Month]@row = 2, February@row, IF([Current Month]@row = 3, March@row, IF([Current Month]@row = 4, April@row, IF([Current Month]@row = 5, May@row, IF([Current Month]@row = 6, June@row, IF([Current Month]@row = 7, July@row, IF([Current Month]@row = 8, August@row, IF([Current Month]@row = 9, September@row, IF([Current Month]@row = 10, October@row, IF([Current Month]@row = 11, November@row, IF([Current Month]@row = 12, December@row)
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Works now. Many thanks.
Its odd what the gremlins get up to when you're away.
-
Excellent!
Happy to help!
Yes, the Gremlins can be a pain. 😉
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!