show vaule of a cell in one sheet into an other

Nefe19
Nefe19 ✭✭
edited 10/25/23 in Smartsheet Basics

I'd like to have the value shown here


Show in this cell on this sheet.



I've tried a vlookup formula and a match lookup but can't seem to get them to work. Any ideas?

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭✭

    Hi @Nefe19


    There are a few ways in which you can get the value in another sheet. The best approach depends on what you're trying achieve.


    1. You can right click on the second sheet in test and click on "Link from Cell in Other sheet...". This will create a link and each time there's an update in sheet 1, it will reflect the value in sheet 2.
    2. If there's a common look up value in both sheets, you can use Index/Match or Index/Collect (if there are multiple conditions) to pull the values.
    3. If the values don't have to sync up in real time, you can use a copy workflow to copy the data from sheet 1 to sheet 2 on addition or change of data.


    Thanks,

    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com