Sheet 1 has the following two columns
Column 1(Yes/No); Column 2 (Date).
In sheet 2, looking for the following Formula:
If value in Column 1 = "Yes", return the corresponding date from Column 2
Any ideas?
Try something like this...
=INDEX({Sheet 1 Column 2}, MATCH("Yes", {Sheet 1 Column 1}, 0))
Here is the formula I'm using:
=INDEX({Food Safety Weekly Training Range 15}, MATCH("Yes", {Food Safety Weekly Training Range 1}, 0))
This is returning an "Invalid Column Value" error.
Thanks for your help!
Make sure both the column the formula is in as well as Range 15 are date type columns.
I didn't have the formula column set as a date . . worked like a charm. Thanks so much!
Happy to help. 👍️
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.