Structure formula

[Lean Li]

Hi,

I'm trying to find a way to present a Phase on an "Initiative" issuetype wich should be an inherited max value in phase field if all it's child issues that have the value have been resolved.

So, according to the example below, the Initiative's phase should be Design, because all its child issues with phase= Design have been resolved.

However, this formula gives the value "Integration" because one child issue with phase=Integration has been resolved (but not all):

IF(issueType = "Initiative", MAX#children{IF(statusCategory = "Done", Phase)}, "")

Example: 

Initiative A

• Epic1
  • Phase: Design
  • Status: Done
• Epic2
  • Phase: Integration
  • Status: Done
• Epic 3
  • Phase: Integration
  • Status: To Do
• Epic4
  • Phase: Roll-Out
  • Status: To Do

Any ideas on how to refine this formula would be greatly appreciated!

[Stepan Kholodov _Tempo_]

Hello @Lean Li 

The formula returns Integration because it chooses the max value between two 'Done'-related values: 'Design' and 'Integration.' The value is chosen alphabetically. If you change the formula from max to min, it'll return 'Integration'.

Best regards,
Stepan
Tempo (the Structure app vendor)