Cell lookup and linking from another sheet
jjanusz
✭
Good Morning All!
Here is my dilemma if anyone can help. I have two worksheets. One has employee ID numbers and a box checked if they have a certain certification. Is it possible to create a formula that essentially says if box gets checked in worksheet A, look in worksheet B for name and check box in worksheet B? Or if a new row/checkbox (not currently on the worksheet) gets added into A a new row will appear in B notifying us to look and put in the new information from A?
Here is my dilemma if anyone can help. I have two worksheets. One has employee ID numbers and a box checked if they have a certain certification. Is it possible to create a formula that essentially says if box gets checked in worksheet A, look in worksheet B for name and check box in worksheet B? Or if a new row/checkbox (not currently on the worksheet) gets added into A a new row will appear in B notifying us to look and put in the new information from A?
Comments
-
Hello,
You can create references to other sheets. You might consider creating an IF statement that checks the box in one sheet when the corresponding box is checked in the other sheet. More on cross-sheet references are available here: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
Here's our complete function list: https://help.smartsheet.com/functions
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