#INCORRECT ARGUMENT SET
Hi Team,
I have been struggling with this formula I need Output urgently. Any help would be highly appreciated.
=IF(AND([Supplier Tender Date]@row > [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row > [Shipment Date (Actual) (To Site)]@row, "Shipment on Time", IF(AND([Supplier Tender Date]@row < [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row < [Shipment Date (Actual) (To Site)]@row, "Shipped Late"))))
Regards
Shubha
Answers
-
You have some misplaced parenthesis.
=IF(AND([Supplier Tender Date]@row > [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row > [Shipment Date (Actual) (To Site)]@row), "Shipment on Time", IF(AND([Supplier Tender Date]@row < [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row < [Shipment Date (Actual) (To Site)]@row), "Shipped Late"))
-
Thanks for your help. But this formula says Invalid Operations. I'm kind of stuck in between, I even tried using this formula:-
=IF(AND([Supplier Tender Date]@row > [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row > [Shipment Date (Actual) (To Site)]@row, "Shipment on Time"), ([Supplier Tender Date]@row < [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row < [Shipment Date (Actual) (To Site)]@row, "Shipped Late"))
& this one says #Unparseable.
-
Hi @Shubha
Think you just needed to close off that final IF statements False outcome?
=IF(AND([Supplier Tender Date]@row > [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row > [Shipment Date (Actual) (To Site)]@row), "Shipment on Time", IF(AND([Supplier Tender Date]@row < [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row < [Shipment Date (Actual) (To Site)]@row), "Shipped Late","")
Test is working
Hope that helps
Thanks
Paul
-
You misplaced the parenthesis again closing the AND functions out in the wrong place. Try the formula as I have it posted above.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!