Aging Bucket Formulae
Hi, Can you please take a look at the below string and point the error
The formulae works for all the buckets but for any cell carrying data over 91, it throws as error as INCORRECT ARGUMENT
Please see to it and suggest.
=IF(AND([Ticket Age]@row >= 0, [Ticket Age]@row <= 7), "0-7", IF(AND([Ticket Age]@row >= 8, [Ticket Age]@row <= 14), "8-14", IF(AND([Ticket Age]@row >= 15, [Ticket Age]@row <= 21), "15-21", IF(AND([Ticket Age]@row >= 22, [Ticket Age]@row <= 30), "22-30", IF(AND([Ticket Age]@row >= 31, [Ticket Age]@row <= 45), "31-45", IF(AND([Ticket Age]@row >= 46, [Ticket Age]@row <= 90), "46-90", IF(AND([Ticket Age]@row >= 91, "91+"))))))))
Answers
-
Thank you. Meanwhile, I fixed the it. Works now.
=IF(AND([Ticket Age]@row >= 0, [Ticket Age]@row <= 7), "0-7",
IF(AND([Ticket Age]@row >= 8, [Ticket Age]@row <= 14), "8-14",
IF(AND([Ticket Age]@row >= 15, [Ticket Age]@row <= 21), "15-21",
IF(AND([Ticket Age]@row >= 22, [Ticket Age]@row <= 30), "22-30",
IF(AND([Ticket Age]@row >= 31, [Ticket Age]@row <= 45), "31-45",
IF(AND([Ticket Age]@row >= 46, [Ticket Age]@row <= 90), "46-90",
IF([Ticket Age]@row >= 91, "91+")))))))
-
Excellent!
Glad you got it working!
✅Please support the Community by marking your post 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
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!