Formula combinations for cross sheet references | Smartsheet Learning Center
https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinationsThere are countless ways to combine functions to analyze your data and make it more useful.
How do I get one sheet to pull a date from another sheet?
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?
Answers
-
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
-
I'm not sure how to send you a screenshot.
-
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:
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
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.
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…
