Am unable to retrieve Dates from one smartsheet to other

While am trying to use vlookup function the limitation threshold is an error prompt. I tried to use Collect and Index Collect function however they are giving me error prompts as # Date Expected and Incorrect Value

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!