How to auto fill a column



I have "Sheet 1" which we work from and "Sheet 2" which we mass upload into. What I want to do is when Im in Sheet 1 and I enter a production order number, I'd like it to go look in Sheet 2 shortages and put them in the comment section in Sheet 1. how can I do that?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!