Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Can you vlook up two sheets?

Nakul Tyagi

Nakul Tyagi ✭

10/04/16 edited 12/09/19 in Archived 2016 Posts

I have related data on two seperate sheets. Like excel - I want to establish v look up for one sheet to update when other is updated with master information

Tags:

Integrations

0 ·

Comments

Brett Evans ✭✭✭✭✭✭

10/04/16

See Kennedy's answer...
https://community.smartsheet.com/discussion/vlookup-function?page=7

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day