Epic status to display the lowest status of linked stories

[Troy]

Hope everyone having a good weekend :)

Looking for some help with Jira automation, so basically I want to set up a manual trigger to update Epic status to reflect the lowest status of the linked stories.

Example, Epic A got 3 User Stories X, Y and Z and is in status 'Writing Requirement'

X has status Backlog (initial status in the Story Workflow), Y has status 'Writing Requirement' (next status in the workflow) & Z has status 'In Dev' (highest status among all three as per the Workflow)

If I trigger the automation rule then it will see the lowest status of the linked stories as per the workflow and update the status of the Epic to that lowest status.