Solved: auto select a value from the list in the dropdow... - Page 2

deprokum · 04-04-2025 08:01 AM

FROM THIS ONE

TO THIS ONE

I have values for list 1, 2, 3 and 4 from the same table with each having a connected list. in this case I use the formula in VALID IF.
normally, when column 1, 2 and 3 of the list are selected, the value in column 4 will automatically appear.
but, what I want is when column 4 is filled, the value from column 4 will automatically be stated, not just displayed. like the second picture below
anyone can help me please

@Steve
@WillowMobileSys

WillowMobileSys

Ok. I see. This is different than I understood.

So the data table POKJA is ALL combinations of the TYPE, COMPANY and MANUFACTURER??

You would want to set Initial Value of your POKJA column to:

SELECT(POKJA[POKJA], AND([Type] = [_THISROW].[TYPE],
                           [Company] = [_THISROW].[Company],
                           [Manufacturer] = [_THISROW].[Manufacturer]))

Sorry, I was confused about what you needed!

View solution in original post

auto select a value ​​from the list in the dropdown

auto select a value from the list in the dropdown