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!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!