VLOOKUP -to auto-populate columns


I would like to auto populate the status of the contracts from one sheet to another. How could this be done?

The sheet below contains the status of the contracts .

There is another sheet I want this to be referenced when they enter the contract number:

Could you pls help me with the formula to do this?


Ranjini Walter


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!