If Function between different sheets
I'm trying to get an if function or something similar to work here. I have two different sheets and I'm trying to match an ID number. If the ID number appears on both sheets, I want the cell value to return with "Yes" and if not, "No". For example, this is the formula I currently have:
=IF([ID Number]1 = {First Year Experience 19-20 Range 1}, "Yes", "No")
Any help would be appreciated.
Thanks.
Best Answer
-
Try something like this...
=IF(CONTAINS([ID Number]1, {Other Sheet ID Column}), "Yes", "No")
Answers
-
Try something like this...
=IF(CONTAINS([ID Number]1, {Other Sheet ID Column}), "Yes", "No")
-
Thanks, that worked great!
-
Happy to help! 👍️
-
I'm trying to do something similar but I continue to get an error message. I have two sheets. In one, employees enter the time they spend on each task. This gets totaled to the column [Total Minutes]. On the second sheet I want to only show date and total minutes. I have no problem doing only one row but when I try to reference a complete column I get the error. This is my formula for one row only:
=IF({Translator Productivity Tool Range 1} = "LZ", {Translator Productivity Tool Range 2})
where range 1 is the employee and range 2 are the total minutes. This works fine but then when I try to reference the whole column it stops working.
Any help would be really appreciated.
Thanks,
-
@Mily Oti I'm not sure I follow.Are you trying to sum a total from another sheet, or...?
-
If trying to use an IF statement using 2 sheets to see if the cells equal same text value and bring back a Yes or No value...
=IF([Applies to Country]@row = {Cnty}, "Yes", "No")
#INVALID OPERATION
-
@dharberts When you are creating the cross sheet reference, are you selecting a single cell? Are you able to provide some screenshots with sample data for context?
-
I want to see if the info (above) form the main sheet matches the info (below) form another sheet, and if the countries exist on both then bring back either a Yes or No
-
If all you need is a yes or no if the country exists on the other sheet, you should should be able to use:
=IF(COUNTIFS({Other Sheet Country Column}, @cell = [Country Column]@row)> 0, "Yes", "No")
-
got it thank you!
-
Happy to help. 👍️
-
got it thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!