Really handed….I’ve done something similar but rather than segments I’ve instead been trying to get this to work in a Derived Property. The logic is similar, but has a load of nesting of IF and AND functions….which seems to break, suggesting that the Derived Properties might not be able to handle nested functions. Do you know if this is the case?

Usually nesting works, but maybe you are going over the limit of 10 property references?

A derived property would be neat, but depending on your desired setup, maybe segments might work better.

Hope you figure it out!