How do I get one sheet to pull a date from another sheet?

T. Schaefer

I have a sheet that has delivery dates and pickup dates that I need another sheet to pull from so I only have to change the dates on the original delivery date sheet. I've tried different types of formulas but I can't get it to pull it to the second sheet. Any suggestions?

Kelly Moore

Hey @T. Schaefer

Is it possible to share screenshots (no sensitive data) of your two sheets, which indication of which sheet is the original? Formulas are dependent on data structure and the number of criteria needed to filter to get to the right data. As one of the more straight forward formulas, INDEX/MATCH is among the first formula combinations to try.

Kelly

T. Schaefer

I'm not sure how to send you a screenshot.

Genevieve P.

Hey @T. Schaefer

You can upload screen captures in your posts here in the public forum, just make sure you block out sensitive data.

In regards to possible formulas, this Help Article has some examples that may suit your scenario:

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations

Cheers,

Genevieve

T. Schaefer

Need the dates from above to connect to the date column in the below list. That way I only have to update the dates in the above sheet.

Eric Law

https://community.smartsheet.com/discussion/comment/409011#Comment_409011

So, to do screen shots, the shortcut is windows key+shift+s or you can just open up the snippit app in windows. If you have an apple, I can't help you there.

to populate the delivery date and pickup date from that sheet, you just need a index/match or vlookup. index/match is better since your dates are not listed alphabetically.

Delivery Date =INDEX(Range of delivery date in your first screenshot, MATCH([Route Day]@row, Range of route days in your first screenshot))

the pickup date is the same as above except you change the range of delivery date in your first screenshot to the range of pickup date. DO NOT just copy paste the formula into the columns as it will not work without your range.