Auto-Fill Rows of Data Based on Criteria


Is there a way to have the Sheet Summary auto-fill multiple values based on a selection from a drop-down field? I would like to have "country" be the drop-down select field and based on the country selected, the fields below would populate based on the values from another sheet.

Example, If Austria is selected then the "Contract" field would auto-populate the value of "60". If the country was then changed to Croatia, the "Contract" field would auto-populate to "50".

Here is the formula I tried to use that works in the smartsheet but not in the sheet summary:

=VLOOKUP([Country - Site]1, {Copy of Time per OB Stage Range 2}, 3, false)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!