Nested IF Statement What do I have incorrect
=IF(Result@row = "", "", IF(Result@row > DATE(TODAY(-30)), "New", IF(Result@row > DATE(TODAY(-60)), "Developing", IF(Result@row > DATE(TODAY(-90)), "Contributing", "Experienced"))))
That is my formula and the Result@row field has Date in it on one row it is giving me an #INCORRECT ARGUMENT SET error. On another row it is giving me an #INVALID OPERATION error.
Both of the results cells being referenced have a different formula that returns a date. I have the column set to Date only restriction and the sheet they are referencing to get the date is also set to Date only columns.
Best Answer
-
Assumption: "Result" column in your sheet is Date type
You do not need to convert TODAY function again into Date type as the TODAY function return Date type by itself. Remove the DATE function conversion around all usages of TODAY function and you should be good. (Btw, syntax for using DATE function is incorrect too.
Try this:
=IF(Result@row = "", "", IF(Result@row > TODAY(-30), "New", IF(Result@row > TODAY(-60), "Developing", IF(Result@row > TODAY(-90), "Contributing", "Experienced") ) ) )
Answers
-
Assumption: "Result" column in your sheet is Date type
You do not need to convert TODAY function again into Date type as the TODAY function return Date type by itself. Remove the DATE function conversion around all usages of TODAY function and you should be good. (Btw, syntax for using DATE function is incorrect too.
Try this:
=IF(Result@row = "", "", IF(Result@row > TODAY(-30), "New", IF(Result@row > TODAY(-60), "Developing", IF(Result@row > TODAY(-90), "Contributing", "Experienced") ) ) )
-
Thank you! That fixed it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!