Formula / Function to copy cells from one sheet to another
Does Smartsheets have a function or formula that will copy a cell from one sheet to another without the manual copy/paste process?
For example, I have a sheet (CDA 1) that will be used to scan a barcode into a cell (Column2 - Row1). I have a second sheet (CDA 2) that I want to auto-populate what was scanned into the cell on the first sheet (CDA 1) to the second sheet (CDA 2) on a cell (Column8 - Row 1).
Doing this in a single sheet, I would just use the "=" in the cell I'm looking to populate and then select the cell I want to copy and it would auto-populate the 1st cell I used the "=" in. However, I cannot find how to do it between 2 sheets.
Thanks in advance!
Comments
-
Hi Jack,
You'd use cell-linking or cross-sheet formulas with VLOOKUP or a combination of INDEX/MATCH.
Are you familiar with those functions?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic day!
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.
-
Thanks Andree!
I think I got it figured out with the "Link Cell From Another Sheet" function when right-clicking in a cell. Too bad it's only limited to 5000 links (not that I need that many any time soon).
However, while I have your attention, do you know if there is a way to hide column visibility from the mobile app without hiding it on the desktop sheet? Thanks again!
-
Happy to help!
Unfortunately, it's not possible at the moment to hide columns just for mobile, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
As a possible workaround, you could maybe create a report that could be used for mobile use.
Would that work?
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!