Error when inserting a cascade selection question

[pmacharia]

I see an error type:Function expected when i try to preview the form after uploading a cascade selection questionUpload.xlsx (9.9 KB)

[Kal_Lam]

Hi @pmacharia,

Welcome to the community! Would you mind sharing your xlsform with the community so that the community could help you out solve your issue.

Have a great day!

[pmacharia]

Hello @Kal_Lam,

i have shared the XLSform

Kind Regards,
Patrick

[Kal_Lam]

Hi @pmacharia,

Could you also share with the community that is in the survey sheet? At the moment you have only shared with what is on the choices sheet.

Maybe as a reference you could have a look at a previously discussed post which should solve your issue:

Weird behaviour in cascading select

Hi @sumankhanal, Welcome to the community! Seems like you have some coding error within your xlsform. I tried at my end with the information you provided and i got it correct. For details, please see the images below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: Please note, you may not see all the choices in the image as i have hidden it to save space. But you should find all the choices in the reference xlsform shared at the end of this post. [Image 2] …

As a backup you could also have a look at the support article Adding Cascading Select Questions.

Have a great day!