ISO Formula to pull data from one smartsheet to another

I am trying to pull a site number from one smartsheet to another based on the date. So when smartsheet 1 is updated and a site moves to another date, smartsheet 2 is updated.

Smartsheet1

Smartsheet2

End Result on Smartsheet2

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!