How to pull avature application date from another sheet


I am stuck coming up with collecting avature application dates from another sheet.

The full name is the column that I want to use from other sheet to pull the avature application date over.

Below is the sheet where avature application date is:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!