Initial values from previous Enumlist

[Koji1]

Please support me on working with Initial where it’s results on a previous Enumlist.

I have 2 spreadsheet
1st sheet name EmployeeDetail have 2 columns Name and Busnumber
2nd sheet name Working have 2 columns OT and BusnumberEmployee

for example, on 1st spreadsheet Name and Busnumber have data and detail of employees and 2nd spreadsheet I setup OT with enumlist on Valid if I used this formular

EmployeeDetail[Name]

so the manager can select multiple employee names here,
then column BusnumberEmployee with initial value I used this formular

LOOKUP([_THISROW].[OT], "EmployeeDetail ", “Name”, “Busnumber”)

but it’s not work correctly if manager don’t select any employees it’s show nothing also if selected multi employees show nothing too, but if selected 1 employee it’s show Busnumber correctly.

I would appreciate for your supporting.

[Steve · Accepted solution]

Try this instead:

SELECT(
  EmployeeDetail[Busnumber],
  IN([Name], [_THISROW].[OT])
)

See also:

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

IN()

Is item in list?

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Koji1]

Thank you for your kindly reply and it’s work perfectly.