What formula do I use?


I have 2 sheets. Sheet one is a grading sheet that goes over appearance, aroma, feel ect. of a production lot. Sheet two is a stock list showing all production lots. Both sheets have the primary column set at Ample number (ID #'s). I want to use a formula in sheet two that copies the final grade from sheet one if the numbers in the primary column match.

So as you see in the pictures provided in the primary column there is a number "1220", I want to copy the "Final Grade of Product" cell from that row on sheet one and add it to the "Final Grade" cell in the row with the matching "1220" in sheet two. What formula would I use and how would I wright it?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!