Can you create an IF Statement using the following?

HYG_Support

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?

Kelly P.

@HYG_Support

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. 😊

Tony Oxa

Is the "/Not Started" a requirement or only when all three columns are BLANK then the task is not started?

HYG_Support

"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.

Kelly P.

@HYG_Support

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!

HYG_Support

@Kelly P.

The CTS is also a Date.

HYG_Support

"In The Field" works but nothing else works.

Kelly P.

@HYG_Support

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. 😊

HYG_Support

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.

HYG_Support

It works.

Thank You,