Gathering information from another sheet with an IF function

Mallory N

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.

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!