=IF(AND(NOT(ISBLANK(

Hi,

I am trying to write a formula saying:

If Forecasted Line Delivery is populated, then apply WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row, 0
if Forecasted Date is Blank, then copy the value from the cell above

My latest attempt looked like this =IF(NOT(ISBLANK([Forecast Line Delivery]@row, WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row, 0), VALUE([Days between Due Date and Forecasted Delivery Date]56)))), which is obviously not correct

Would welcome any help, many thanks

Find more posts tagged with

Accepted answers

All comments

Mark.poole

Try

=if([Forecast Line Delivery]@row<>"",WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row,0),VALUE([Days between Due Date and Forecasted Delivery Date]56))

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.