Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Update field in another sheet
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?
Comments
-
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.
- https://help.smartsheet.com/articles/861579-cell-linking
- https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hello Team, May be this is intentional, but want to double check. In a sheet, when i open the conversations window, I am able to see tabs for "Row", "Sheet" "All" and "Unread". On the contrary, in a r…
- Can I and how do I set conditional formatting for a Finish Date font to be red if the date is in the past and % Complete is not 100. Is there a way to set multiple conditions for Conditional formattin…
- Hi Smartsheet Community, I have a question regarding Gantt charts in Smartsheet. Currently, my Gantt chart displays a single bar for each project, representing the overall project start and end dates.…
