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
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!