How to add another sheet reference into IF formula...
Hi! I just want to add another sheet reference into the below IF formula... It might need an AND statement, but I could not find a solution for it.
=IF(CONTAINS(Number@row, {Sessions 1 Range 1}), "True", "False")
Any ideas?
Answers

Would need more information about what you are trying to do to know for sure but it sounds like you would need a nested if statement
If(Contains(number@row,{Sessions 1 Range 1}),If(Contains(number@row,{Sessions 2 Range 1},"True","False"))

Thanks for your feedback! I'll try to use the nested IF statement as you proposed, see here:
=IF(CONTAINS(Number@row, {Sessions 1 Range 1}), IF(CONTAINS(Number@row, {Sessions 2 Range 1}, "True", "False")))
Unfortunately with an Error saying "#INCORRECT ARGUMENT SET".
Basically I want to check if a certain cell in multiple sheets has the same value as in a certain cell (Number column) in the main sheet where the formula is located.

Try an IF/OR.
=IF(OR(CONTAINS(sheet1), CONTAINS(sheet2), CONTAINS(sheet3)), "True", "False")

Ok, this one did not work...
=IF(OR(CONTAINS(Number@row), CONTAINS ({Sessions 1 Range 1}), CONTAINS ({Sessions 2 Range 1})) "True", "False")
Any suggestions?

You would use the same CONTAINS syntax you have in your first formula. Just update the range in each for sheet 1, sheet 2, etc..

I can't make it work... struggle with the syntax. Can you correct this formula accordingly?
=IF(OR(CONTAINS(Number@row), CONTAINS ({Sessions 1 Range 1}), CONTAINS ({Sessions 2 Range 1})) "True", "False")
Thanks for your help! I really appreciate it.

You already have the proper syntax for CONTAINS in your original formula:
CONTAINS(Number@row, {Sessions 1 Range 1})
You would use that same syntax but create new cross sheet references in each to point at each of the sheets in question.

Thanks Paul, it worked now! :)

Happy to help. 👍️
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