I have an app where I can see different work items with different status. When the work items enter the app they have all status "New". I have build an function with help of the patchfunction so I can change status. The problem is that the dropdown1_17 shows only the status that is available right now. So if all work items has status new I can only change to status new in the dropdown1_17. but if one of the work items has another status then I can change to other statuses too beside status "New". I want the status on dropdown1_17 be fixed to 6 statuses so I can allways choose between these 6 statuses. It should also change in my Excel file to the new status.
Dropdown1-16 is filterering on the current status (doesn't need adjustment)
Dropdown1_17 (need adjustement)
the dropdown is connected to my excel file column Status
I think right solution is to connect the dropdown1_17 to another Excel page but I don't know how to do that and at the same time update Status in the first page (Ticket)
@mdevaneyalmost fixed. I don't get any errors but when I click on the checkbox it update to the new status automatically. I want to click on the confirm button to do that.
I have also problem with that the new status appears in a new field in my dropdown. I think I should use distinct somehow.
User | Count |
---|---|
150 | |
100 | |
89 | |
78 | |
58 |
User | Count |
---|---|
194 | |
186 | |
106 | |
99 | |
91 |