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)