Update Symbol based on another sheet's Symbol
Simple question that I'm frustratingly close to figuring out.
On Sheet A, I have a column for a list of {Operators} with a {Discipline} column next to it, indicating whether or not said Operator is cleared on said Discipline. We're using the "Yes," "Hold," and "No" symbols.
On Sheet B, I have, essentially, the exact same thing. The only difference is that for Sheet B's Operator column we'll be using a dropdown list. So, the goal is that when someone updates the dropdown column with a specific Operator, it'll spit out that Operator's cleared Discipline.
This can either "copy" the cell from Sheet A, because it'll be the exact symbol, or update the cell in Sheet B. I know it's simple, I'm just not formula-savvy.
Best Answer
-
Hey @celtics345
If I understand correctly, someone will manually add the Operator's name to Sheet B (through a dropdown list). Once the name is added to Sheet B , one can use an INDEX/MATCH in the Sheet B Discipline column.
=IF(Operator@row<>"", INDEX({Sheet A Discipline column}, MATCH(Operator@row, {Sheet A Operator Column},0)))
Because this is a cross sheet formula, you must physically build your own cross sheet references through the formula window. You cannot simply copy paste this formula
Does this work for you?
Kelly
Answers
-
Hey @celtics345
If I understand correctly, someone will manually add the Operator's name to Sheet B (through a dropdown list). Once the name is added to Sheet B , one can use an INDEX/MATCH in the Sheet B Discipline column.
=IF(Operator@row<>"", INDEX({Sheet A Discipline column}, MATCH(Operator@row, {Sheet A Operator Column},0)))
Because this is a cross sheet formula, you must physically build your own cross sheet references through the formula window. You cannot simply copy paste this formula
Does this work for you?
Kelly
-
This is incredible Kelly, thank you very much! I guess I wasn't so close after all. Looks a bit above my level of understanding. I figured INDEX and MATCH would be involved. Worked on the first time, thank you as always!
-
Anytime!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!