Color calendar if field *contains* a certain word or character

Question

I'm wondering if I can assign a color to a line on my calendar if the field just _contains_ a word or phase in it...not the entire field text?  For example, my field has the phrases "Truck 1" or "Truck 2" in them, followed by verbiage on time frame we are to be at that customer.  I'd like all the ones that say "Truck 1" to be the same color, regardless of what comes after that phrase.  Same with "Truck 2".  Can this be done with a formula some how?  Thx, Mark

QuickBaseCoachD · Answer

There are several ways to do this but I suggest making a field like this, as a formula text field type called

IF(
Contains([My field],"Truck 1"), "Red",
Contains([My field],"Truck 2"), "Yellow")

Now you have a text field. The just use the native options to select a color for each of those choices. Any text or checkbox field can be used to set a color.

Sign up

Login to the community