Reflect the status of the subitems to the parent status
Support 4 replies 0 likes 0 votes 182 viewsI'm currently on the trial period of the RSI application and ready to activate the application on 4 boards in our company. The only problem I have is a scenario where the desired functionality is not achieved. In my subitems, I have 6 statuses: {Not Started, Working on it, To Check, Done, Stuck, Cancelled}. However, for rolling up my subitems, I'm only interested in 4 of them: {Not Started, Working on it, To Check, Done}. So, I create a filter for this as listed in the picture.
The desired functionallity I want to have is summarized below.
- If 100% of the subitems have the status Done, for exception of Stuck / Cancelled => Roll up the status of the parent to "Done"
- If > 1% of the subitems have the status To Check (So basicly if one subitem has the status To Check) => Roll up the status of the parent to "To Check"
- In all the other cases, put the status on "Working on it" => Roll up the status of the parent to "Working on it"
I implemented this RAG system with the following automation (I already set up the automation for the trigger on update/create/delete):
It seems to work just fine, except for the following scenarios. I create an item (Parent item) with, for example, 5 subitems. The moment I change the status of one single subitem to "Done" (with the 4 other sub items having status "Not Started"), the parent is wrapped up to the status "Done". However, this is not the desired outcome because I only want the wrap up if 100% of the subitems have their status set to "Done". Can you please further assist me with this issue?