Sign in to join the conversation:
Hi there, i'm trying to figure this out: I have sheet #1 with an email address field. When that field is updated, Smartsheet automatically updates sheet #2 email address field with the email entered in sheet #1. Is this possible?
Yes, but the exact solution will depend on your setup.
Are you able to provide a screenshot with sensitive/confidential data replaced with "dummy data"?
How are your sheets set up? Is it a basic Name in one column and email in another kind of thing? How long is your list?
It sounds to me that you might want to do cell-linking. But as Paul said, it could be that doing a Vlookup with cross-sheet references is a better solution. It really does depend on what you are trying to accomplish in the long run. Screenshots and purpose for pulling that data help us to coach on the appropriate method. These articles might provide you with some valuable information.
Hi Kayla
It sounds like VLOOKUP or a combination of INDEX/MATCH could also be an excellent solution.
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hi Team, I notice when I initially submit an email from the Dynamic View to the submitter, a notification isn't triggered to them of my comments, but I receive an email when the submitter replies back to me. I had the submitter check their spam and junk folders for my email, but it wasn't available. Is there a solution for…
I developed a comprehensive End-to-End Testing platform using Smartsheet. After my client completed their initial 4-week testing cycle, we held a feedback session. One key area they highlighted for improvement was managing the volume of @mentions using conversations they were receiving . They found it challenging to keep…
We are looking to implement a more quantitative, objective prioritization method for our project portfolio. What are some of the best ways to set this up in Smartsheet? If you include on your intake form, how do you count on those submitting to be objective?
