Problem in ranking the items needed

What is the problem? Please be detailed.
Hi All,I have problem in ranking the items needed most during nonfood distribution e.g solar light,torch,parafin lamp,cooking set and shelter tools.please need help in here in how to design the questionnaire on the xls form

What ODK tool and version are you using? And on what device and operating system version?

What steps can we take to reproduce the problem?

What you have you tried to fix the problem?

Anything else we should know or have? If you have a test form or screenshots or logs, attach here.

HI @Adordeng

we have a sample form with all widgets https://docs.google.com/spreadsheets/d/1af_Sl8A_L8_EULbhRLHVl8OclCfco09Hq2tqb9CslwQ/edit#gid=0

at the end of the form you can find rank widget which you need.

Even am facing same issue while doing it manually whereas while doing with a widget it is working fine as of now. But still not able to get a way out how to do without widget!

Regards,
Smith