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.
Answers
-
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!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
-
Thank you! Worked like a charm!
Help Article Resources
Categories
Check out the Formula Handbook template!