Match + field is checked, check this box
Hey all - having trouble with this formula. I just need a box to be checked if:
If the number id in sheet A is found on sheet B AND the box on sheet B in a second column is checked…then check the box in sheet A
Here's what I have so far - maybe it should be AND(INDEX(?
=IF(INDEX({UCA E#}, [E# or Group]@row, {Affiliate individual}, true), true, false)
Best Answer
-
This works actually:
=INDEX({Column to return}, MATCH("Matching Value", {Column with value to match}, 0))
Pulled it from SS help documents…go figure lol.
thanks for your help @Michelle Choate 2
Answers
-
Try this: =IF(AND({UCA E#}, [E# or Group]@row,{Affiliate individual}, true), true, false
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
Thanks @Michelle Choate 2
I got an invalid data type.. So it doesn't need index? [E# or Group]@row has to look for a match in the whole column of {UCA E#} and then if it finds a match it needs to only check the box if {Affiliate individual} on that same row it found is checked.
-
This works actually:
=INDEX({Column to return}, MATCH("Matching Value", {Column with value to match}, 0))
Pulled it from SS help documents…go figure lol.
thanks for your help @Michelle Choate 2
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!