IF formula is not working as expected
I'm sure I'm doing something wrong with this formula, but I can't figure out :(
Any help is much appreciated!!
I'm trying to add a text to the column "Dispute", so if the # of days in the "Days from Audit" column is equal or higher to 10 text will be "Dispute not applicable" or if the # of days in the "Days from Audit" column is equal or lower than 9 the text will be "Proceed with Dispute Form"
This is the formula I have:
=IF([Days from Audit]@row < "9", "Proceed with Dispute form", IF([Days from Audit]@row >= "10", "Dispute not applicable"))
Best Answer
-
Greetings @Xochitl C. ,
Based on what I can see, you do not need the parenthesize around the numbers in your if statement.
Please try the following formula and see if this works correctly for you:
=IF([Days from Audit]@row < 9, "Proceed with dispute form", IF([Days from Audit]@row >= 10, "Dispute not applicable", ""))
I hope this helps and have a great day.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. π
Answers
-
Greetings @Xochitl C. ,
Based on what I can see, you do not need the parenthesize around the numbers in your if statement.
Please try the following formula and see if this works correctly for you:
=IF([Days from Audit]@row < 9, "Proceed with dispute form", IF([Days from Audit]@row >= 10, "Dispute not applicable", ""))
I hope this helps and have a great day.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. π
-
Thanks @Frank S. it worked!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 376 Global Discussions
- 205 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!