Formula Question for IF(AND(NOT(ISBLANK(

I have a sheet that contains book information and want to index/match date from another Smartsheet as long as the date in the column called Most Recent Available Date@row is greater than today AND InventoryID@row is not blank.
If either of these is not the case, then I just want an empty cell. Here is the formula I entered, but its UNPARSABLE and I can't see what I've missed.
=IF(AND([Most Recent Available Date]@row>TODAY(), NOT(ISBLANK([Inventory ID]@row))), (INDEX({GUIDEP0STS-- Product Manufacturing Sched WHSE DT}), MATCH([Inventory ID]@row, {GUIDEP0STS-- Product Manufacturing Sched ITEM CODE}, 0)), " ")
Any help would be greatly appreciated. Thanks.
Answers
-
@Jwindels I think there are some extra parenthesis, see if this one works: =IF(AND([Most Recent Available Date]@row>TODAY(), NOT(ISBLANK([Inventory ID]@row))), INDEX({GUIDEP0STS-- Product Manufacturing Sched WHSE DT}, MATCH([Inventory ID]@row, {GUIDEP0STS-- Product Manufacturing Sched ITEM CODE}, 0), " ")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 150 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!