Match formula

Is there a way to have a sheet update from another. for isntance if the addresses match i need the new information submitted in one of the columns to then be entered into the column of the other sheet.

Also, aditionally if someone uses the same address each month as a location but i need the most recent submission with response for that second sheets column how do i make sure that happens


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!