Color Coding - Calendar Report
I have the below formula working:
If(Contains(ToText([Origin Name]),"lineage"),"#fce069",
Case(ToText([Shipment Status]),"Delivered","#dadada", "Booked","#f0f0f0", "Rated","#f0f0f0", "Scheduled","#f0f0f0", "In Transit","#f0f0f0", "Delivered ; In Transit","#f0f0f0"))
This puts any Name with the word lineage in it as Yellow, then any Delivered status Grey and the other remaining Status' Green.
How can I change this so that if it contains "lineage" it is Yellow but all other default to Green? Can you do a NotContains formula?
------------------------------
Alycn Bjergo-Justen
------------------------------
If(Contains(ToText([Origin Name]),"lineage"),"#fce069",
Case(ToText([Shipment Status]),"Delivered","#dadada", "Booked","#f0f0f0", "Rated","#f0f0f0", "Scheduled","#f0f0f0", "In Transit","#f0f0f0", "Delivered ; In Transit","#f0f0f0"))
This puts any Name with the word lineage in it as Yellow, then any Delivered status Grey and the other remaining Status' Green.
How can I change this so that if it contains "lineage" it is Yellow but all other default to Green? Can you do a NotContains formula?
------------------------------
Alycn Bjergo-Justen
------------------------------
