How do I reference another sheet for a specific value and it must return another cell value?


For example:

Source Sheet

Immediate Action Sheet

What I am trying to do in the Immediate Action Sheet is: If 'Require Immediate Action' column in the Source Sheet is a "Y", I want Case ID to populate along with the User ID.

Immediate Action Sheet - Final result

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!