Return value of another cell

tsammons

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?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try something like this...

=INDEX({Sheet 1 Column 2}, MATCH("Yes", {Sheet 1 Column 1}, 0))

tsammons

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!

Paul Newcome

Make sure both the column the formula is in as well as Range 15 are date type columns.

tsammons

https://community.smartsheet.com/discussion/comment/324789#Comment_324789

I didn't have the formula column set as a date . . worked like a charm. Thanks so much!

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.