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
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
