Changing the main item Status based on the status of it's sub items

[viraj.jadhao]

I am working on a board where I have several sub items under 1 main item. There are different status columns in both, main and sub items.
Main Item Status: Under review, Signed off, On hold
Sub Item Status: Signed, Stuck, In review, Comment sent, Response received

I want to automate the board in such a way that if the status of all the sub items is anything EXCEPT Comment Sent, The status of the main item should change to Under Review.

I want Monday to look at the status of all the sub items inside the main item and if none of the status is Comment sent, Change the Status of the main item to Under review.

Please view attached screen shots for a better understanding of my question.

[basdebruin]

The Rollup Subitems app support highly configurable parent status columns (RAG style) based on subitem status columns.

[viraj.jadhao]

Will Rollup Subitems app help me automate changing the parent item based on conditions I provide in the Subitems? I have submitted a request for the app. I will go through it in detail once approved. Thanks.