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
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
It does not matter which data I select, I am getting the error of Selected data cannot be charted. I even tried reusing a report that is producing a chart on a different dashboard, but I am unable to create new charts in a dashboard. Anyone have any ideas as to why?
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.
