Automatically copy cell based on 2 criteria in another sheet


I am trying to take 1 cell (Term) from my "Active" sheet and I'd like it to autopopulate my Eligibility sheet with a course name, based on the Active Sheet and the Term and name selected.

So Term has F/S and the course names can be 1 of 8 different courses. I'd like it to first recognize the Term (either F(all) or S(pring)) and then match the student name and the dropdown course selected in the Active Sheet and return the Course to the respective Fa acceptance or Sp acceptance column in my eligibility document.

Is there any way to do this? Please and thank you!


Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!