I have the following formula field that works perfectly to set the Expiry Status.
The problem with having a text Expiry Status is that I cannot use it for KANBAN views (and also it does not show in cool colors!).
If I had a single select field for Ex...