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