Combine Data from 2 sheets using one common column as a link.

I have 2 sheets

  1. training of Team Members with their certificates as an attachment (see screenshot)
  2. position assignments of Team Members

B (see screenshot)oth sheet have email address as a common link already used for formulas reporting if training was completed and training class names.

Already have one report of the training sheet sh(1) owing the certificates, but want to include the 2nd sheet showing their position assignments. but the columns are showing as blank in the report.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!