Formula to match two column inputs within one row in two separate Smartsheet's.

Roster Smartsheet:

Course Email Eval Completed

Class1 Joe@email.com =formula here

Class1 Jane@email.com =formula here

Class2 Joe@email.com =formula here

Evaluation Smartsheet:

Course Email

Class1 Joe@email.com

Class1 Jane@email.com

Class2 Joe@email.com

Formula that doesn't work:

=IF(AND(RosterSS[Course]=EvaluationSS[Course],RosterSS[Email]=EvaluationSS[Email]),"yes","no")

QUESTION:

How can I write the formula to look up the course column and email column in two different Smartsheets and match them to answer Yes or No on whether each email (student) has completed a course eval for the class they attended.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!