How do I pull dates from one sheet to populate onto another sheet based on an address
Good Afternoon, I am novice to Smartsheet and require some assistance. I have a sheet- let's call it Sheet A-that has a form linked to it. My colleagues complete this form when they go visits sites, and the information auto-populates onto Sheet A.
I have a second sheet-let's call this one Sheet B.
I copied and pasted all the sites' addresses from Sheet A to B. but now I want to pull the follow up dates from Sheet A onto Sheet B. I want to use the addresses as the criteria.
The formula I am trying to use is:
=INDEX({follow up date}, MATCH([Space Identifier]@row, {Office Address}))
Someone please help!!
Answers
-
Try this modification first:
=INDEX({follow up date}, MATCH([Space Identifier]@row, {Office Address}, 0))
-
I tried that as well, it does not work. I either get #NO MATCH (even when there is an address matching) or #INVALID COLUMN VALUE.
-
Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?
-
I was able to figure it out! The column type was incorrect.
This is the formula I used in the cells:
=INDEX({Follow-Up EOC Visit - Reports & Tracking Range 1}, MATCH(Office@row, {Office Address}, 0))
Is it possible to use this same formula, but now filter out dates and only have dates between 10/1/2023 to 9/30/2024?
-
You would need to change it to an INDEX/COLLECT.
=INDEX(COLLECT({Follow-Up EOC Visit - Reports & Tracking Range 1}, {Office Address}, @cell = Office@row, {Date Range}, AND(@cell>= DATE(2023, 10, 01), @cell< DATE(2024, 10, 01)))
-
Hmm i am still having issues.
In your formula, is "{Date Range}" just typed in? Or is this referencing a column on another sheet?
-
You would have to create a cross sheet reference to the date column in your source sheet the same way you created the other cross sheet references.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 358 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!