Problem with returning a result when between 31 and 90 days...
I have a sheet that I am trying to return a 1 if the due date is within the next 30 days, a 2 if the due date is between 31 and 90 days, and a 3 if the due date is over 90 days. The formula below returns the 1 correctly but gives me an #Incorrect Argument error for the others. Can anyone let me know what I am doing wrong? Thanks so much in advance!
=IF([Due Date]@row <= TODAY(+30), 1, IF(AND([Due Date]@row <= TODAY(+31), [Due Date]@row <= TODAY(+90), 2, 3)))
Answers
-
Greetings @SASardy,
Please give this formula a try:
=IF(Date@row <= TODAY(30), 1, IF(AND(Date@row >= TODAY(31), Date@row <= TODAY(90)), 2, 3))
Let me know if you need additional help.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
-
@Frank S. I tried your formula and Smartsheet said the formula syntax isn't quite right.
Never mind, I figured it out. Thank you so much!
-
My apologies; I should have clarified that you would need to change the Date@row to whatever column name you wanted to check the date.
I'm glad it worked out for you, and I hope I got you on the right path.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!