Gathering information from another sheet with an IF function

I am trying to gather information from another sheet and then (possibly) use an =IF statement to format another sheet, but I can't figure out the formula that I need to use.

A little more information:

I have one sheet with raw data on it. I'd like to use this data on another sheet to create a "yes" or "no" text return. So saying, if in a row with this sales order number, if a certain column has a value greater than zero then on my non-raw data sheet I'd like it to appear as "yes". Is this possible?

Also, I'm using SmartsheetGov, if that matters.

Find more posts tagged with

IF(

Accepted answers

All comments

SSFeatures

Hi @Mallory N,

Yes this is possible!

For example, this is my test sheet.

In my other sheet that needs to reference this data, I create a cross-sheet reference.

I need a cross-sheet reference for both the Sales Number and the Value. Then I use this formula in my second sheet:

=IF(INDEX({Sheet A Value}, MATCH([Sales Number]@row, {Sheet A Sales Number})) > 0, "yes", "no")

This formula matches the Sales Number for the row between both sheets, looks at the value, checks if the value is greater than 0, and then outputs a "yes" or "no".

You can also make the formula a Column Formula so that it applies to the entire column.

I hope this helps!

Mallory N

Thank you! Worked like a charm!

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.