Trying to compare cells to update dates

Trying to find matching serial numbers, then use delivery date of the first entry to derive support date of 2nd entry. The below works for the initial entry but the Extension Order gets #Invalid Data Type error. Thank you in advance for your suggestions.

=IF([Order Type]@row = "New HW", DATE(YEAR([Delivered Date]@row ) + VALUE([Years of Support Purchased]@row ), MONTH([Delivered Date]@row ), DAY([Delivered Date]@row )), IF([Order Type]@row = "Extension Order", DATE(YEAR([Delivered Date]@row ) + VALUE([Years of Support Purchased]@row ), MONTH([Delivered Date]@row ), DAY([Delivered Date]@row )), ""))

Find more posts tagged with

Formulas

Accepted answers

All comments

KPH

Good news, is the formula looks fine. Bad news, is that makes it harder for someone else to troubleshoot. Can you check the date in the row with Extension Order is really a date (maybe try changing the column setting to allow dates only and see if it mentions an error).

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.