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 nonraw 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 crosssheet reference.
I need a crosssheet 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!
SSFeatures  The browser extension that adds more features into SmartSheet.
 Automatic sorting, sorting with filters, saving sort settings
 Spell checking
 Report PDF generator that supports grouped and summarized reports

Thank you! Worked like a charm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!