Google spreadsheet data as list picker elements

[Khargeswar_Roy]

Hello kodars,
I am using google spreadsheet extension from app helper. I want to call username column data from google spreadsheet and set the data’s as list pickers elements. But It is showing this issue. I have to submit this application at my office to manage the field user report.

[Still-learning (1-2-3-4...)]

Two factors you should listen

1. Check the data obtained from spreadsheet to your app or show us your spreadsheet screenshot. Your error shows it is not in list or csv row
2. Another one instead of kist picker text or elements you have choosen enabled. See to that also

[Khargeswar_Roy]

Thanks @Still-learning.It is working now.

[Khargeswar_Roy]

I have one more query. How to get the row number from the value of a cell.