Auto-Fill Rows of Data Based on Criteria

Stephanie Bauder

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)

CP Business Locations1.xlsx

Andrée Starå

Hi Stephanie,

What happens? Do you get an error message or wrong value?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Stephanie Bauder

Hey Andrée,

I don't get an error message at all! The field just remains at "60" and doesn't auto change to "50".

Andrée Starå

Ok.

I'd be happy to take a quick look!

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)