I'm trying to add "days" to a Date.
The formula in the "Test" column is:
=[Ex Works]@row + (IFERROR(INDEX({business days}, MATCH(Location@row, {location}, 0)), ""))
This is the error that I'm getting. I'm not sure what I'm doing wrong.
I was able to get it to work.
I hope this helps
You're welcome :)
OMG! I had the "Test" column as text, not a date.
I can't believe that I didn't see that.
Thank you so much!!!!
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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.