Survey123 connect cascading sheets not working

[JessicaRamirez1]

Hi, 

I'm having an issue getting my survey to work. I have 4 select_one questions, Division, Market, Portfolio, and then finally property. I can't seem to get past the portfolio part it has no options for me to choose. I need to be able to drill down to the property. I have attached my survey.

[DougBrowning]

For the OffPortfolio list you are trying to use the OffMarket column but that column is blank for the OffPortfolio list.

You need to add the values like this 

OffPortfolio

Campus

Campus

Office

Chicago

[JessicaRamirez1]

Hi Doug,

Thanks for the reply. I added the OffMarket to the OffPortfolio, my sheet looks like this.

I can drill down to Select Portfolio now. However, all the choices for PropertyListOff shows up instead having these questions filter out for the ones I want.

[DougBrowning]

I am not sure what you want to filter in the last question.  By city or Office vs Campus.  If Office v Campus it works for me.

[JessicaRamirez1]

Hi Doug, 

I am filtering by division (for Office), then my filter by OffMarket to get city location, then filter by OffPortfolio to get the campus of office, then I want to select a property. No mater what I seem to do I can't get the properties to show up correctly off of the PropertyList. My example is selecting the office division, then select the Chicago market, then select office. Now if I select a Property I should only get 3 properties that show up. I only get the properties that have been filtered by division and by Portfolio, my market is not being used to filter for my property choices.

[DougBrowning]

So are you saying you want it filtered by Office and Chicago?  It is not going to filter twice automatically for you.

You are telling it to filter the PropertyListOff list by the OffPortfolio field which is exactly what it is doing.

[JessicaRamirez1]

I see thank you for clarifying. Do you know of a way to be able to filter it down one more time? 

[DougBrowning · Accepted solution]

You can filter by more than one column.  So something like this for Property 

OffPortfolio=${OffPortfolio} and OffMarket=${OffMarket}

[JessicaRamirez1]

Thanks Doug, it worked!