I am working with single select option present in monday forms. I am facing some challenges.
Following are the challenges I am facing.
NOTE:
- Single select in form creates column in board.
- Tiers1 and Tiers2 column created through this form
- Every new column(Tiers) depends on previous columns(Tiers)—>eg Tiers2 depends on Tiers1
STEP1:This is the single select option in monday form
STEP2:With the help of this I created column Tiers1
STEP3:Now for every option(software, hardware, network) I created Tiers2 with include condition.
STEP4:Problem starts from here, when I submit this form it creates separate column in monday board
STEP 5: I want only single column of Tiers2 that filter out values as per selection of Tiers1 without giving two extra column of Tiers2
STEP 6: Now when I create Tiers3 column for every option of Tiers2(s1,s2,s3) it will create separate 3 columns(Tiers3) for every Tiers2(s1,s2,s3) option .
e.g. for software(s1, s2, s3) it will create separate 3 Tiers3 column
SOLUTION WE NEEDED:
1. I want only single column of Tiers2 that filter out values as per selection of Tiers1 without giving two extra column of Tiers2
2.:I want only single column of Tiers3 that filter out values as per selection of Tiers2 without giving any extra column of Tiers3
3.If you have alternative solutions like automations etc in monday.com most welcome.