Sign in to join the conversation:
I would like some help trying to figure out a "VLOOKUP" formula. I am trying to get the circled number on the attached file to go onto another sheet. I have tried all different ways and I cannot seem to get it to work. Please help.
It almost sounds as if cell linking would be more what you need than a VLOOKUP.
Hi,
If it's always the same cell, you could use cell linking instead.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
I am really new to smart sheet. Can you explain?
Happy to!
The easiest way is to go to the sheet with the information that you want to show in another sheet.
Select the cell(s) and right click and choose "Copy" and then go to the sheet where you want the cell(s) information to show and select the cell where that information should be and right click and "Paste Special" and select "Links to copied cells".
Mor information: https://help.smartsheet.com/articles/861579-cell-linking#create
Andrée
That worked, however I want the number to change on one sheet when a number is changed on the other.
Great!
That's the way the cell link works. If the number changes on the source sheet the cell on the destination sheet updates with the same information. It can only be one way.
Thank you
Happy to help!
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
I looking to find unique values, in order, and separate them into columns. The "Client Update Date" column will contain dates, not in order and some dates may be duplicated. In the "1st Date Feedback I'm getting the correct date of 12/12/25 with the formula: =MIN([Client Update Date]:[Client Update Date]) In the "2nd Date…
