IF(AND(NOT(ISBLANK Formula Trouble...
Hello all,
I'm having trouble nesting the IF(AND(NOT(ISBLANK formula.
If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column, I want the cell to say approved... this is what I have.
=IF(AND(NOT(ISBLANK([Provisional Requested Amount]@row)), [Provisional Requested Amount]@row <= [Final Requested Amount]@row, "Approved"))
Thanks in advance.
Best Answer
-
=IF(AND(NOT(ISBLANK([Provisional Requested Amount]@row)), [Provisional Requested Amount]@row <= [Final Requested Amount]@row), "Approved"
Answers
-
=IF(AND(NOT(ISBLANK([Provisional Requested Amount]@row)), [Provisional Requested Amount]@row <= [Final Requested Amount]@row), "Approved"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!