Color Coding - Calendar Report

Question

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------------------------------

MarkShnierYou · Answer

I don't know what all your color codes mean vs yellow and green,

but this is a valid syntax

IF(not Contains ([some field], "linage") ......

ie you can use the word not

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community