List Range In Zoho Sheets Data Validation

Hello,

I have 2 worksheets "Sheet 1" & "Sheet 2".

I want to set data validation in Sheet 1 but using a named range for the drop-down list.

I have set a dynamic named range CSID "OFFSET(Sheet2.$A:$A;0;0;19999;0)".

I tried typing in CSID in the list or cell range but it didnt work like Excel.

Please help, thanks.