Can you create an IF Statement using the following?
If Actual Build Date is Blank, Clear to Ship is Blank, and Actual Ship is Blank, then put "Not Started"
If Actual Build Date is Not Blank, Clear to Ship is Blank, and Actual Ship is Blank, then put "Factory"
If Actual Build Date is Not Blank, Clear to Ship is Not Blank, and Actual Ship is Blank, then put "Clear To Ship"
If Actual Build Date is Not Blank, Clear to Ship is Not Blank, and Actual Ship is Not Blank, then put "In The Field"
Can you combine all 4 statements together?
Best Answer
-
Okay, then try this (modify the column names in the formula if they differ from the grid you supplied in your question):
=IF(AND(ISDATE([Actual Build Date]@row), ISDATE([Actual CTS]@row), ISDATE([Actual SHP]@row)), "In The Field", IF(AND(ISDATE([Actual Build Date]@row), ISDATE([Actual CTS]@row)), "Clear To Ship", IF(ISDATE([Actual Build Date]@row), "Factory", "Not Started")))
Hope this helps. 😊
Answers
-
Is the "/Not Started" a requirement or only when all three columns are BLANK then the task is not started?
-
"Not Started" is a requirement but could also be "Not Started" when the Actual Build Date is Blank and any of the following two columns are Blank.
-
Try this (it assumes Actual Build Date and Actual Ship are dates, and CTS is a checkbox):
=IF(AND(ISDATE([Actual Build Date]@row), CTS@row = 1, ISDATE([Actual Ship]@row)), "In The Field", IF(AND(ISDATE([Actual Build Date]@row), CTS@row = 1), "Clear To Ship", IF(ISDATE([Actual Build Date]@row), "Factory", "Not Started")))
Hope that helps!
-
The CTS is also a Date.
-
"In The Field" works but nothing else works.
-
Okay, then try this (modify the column names in the formula if they differ from the grid you supplied in your question):
=IF(AND(ISDATE([Actual Build Date]@row), ISDATE([Actual CTS]@row), ISDATE([Actual SHP]@row)), "In The Field", IF(AND(ISDATE([Actual Build Date]@row), ISDATE([Actual CTS]@row)), "Clear To Ship", IF(ISDATE([Actual Build Date]@row), "Factory", "Not Started")))
Hope this helps. 😊
-
It gives me an error stating Incorrect Argument Set for "Not Started", "Factory" and "Clear To Ship" fields. But the "In the Field" works correctly.
-
It works.
Thank You,
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!