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?

Find more posts tagged with

Accepted answers

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

All comments

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):

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,

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.