Solved: Dropdown list created using Valid if function is n... - Page 2

rajkhandelwal · 08-12-2021 09:15 PM

Hi All,

I have a customer list sheet and a customer work sheet. I am using the name of the customer from the customer list sheet in the customer work sheet as drop-down using valid if function as shown in the picture below.

The issue is when I change/update the name of the customer in the customer list sheet, it doesn’t automatically update the used name in the customer work sheet by itself. I have to go edit it and then it shows to change.

Please help me to resolve it!

Aurelien

Hi @rajkhandelwal

From my understanding of your need, you don’t need to specify the valid_if like you did.
You probably want to set the type into Ref, instead of Text, and pick the source table on your Customer table.
In this Customer table though, you will need to tick the “label” option on the customer name column, so that the user will see all the customer names in the dropdown.

View solution in original post

Dropdown list created using Valid if function is not updating