Welcome!

Cell lookup and linking from another sheet

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?

Find more posts tagged with

Healthcare

Project Management

Cell linking

Comments

Shaine Greenwood

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

Sign in to join the conversation!

Quick Links

Trending discussions

Delete Comments
Hi Team, How can I prevent a non admin end user from deleting a comment or comment thread in the dynamic view? Also, how can I notify the end user by email of the comment sent?
Conversation Trail
Is there a way to create back and forth conversations in the Smartsheet dynamic view with clients about their request that also records the back-and-forth history? I created a feature in the details panel that points at the comment text box which I add comments BUT if the requestor responds back, historical comments can be…
Pull data from a row
I'd like to pull data from a Smartsheet row, having designated specific columns, and put it into a document that can be printed.