Conditional formatting - Calendar view

I would like all of the events to be a different color on the calendar I am creating however if I use "type of event" as the condition, they all end up the same color on the calendar even if I set them differently. I have tried setting AND conditions as well but they end up the same color.

For example, if I set "Moda center event" AND operation order - ops order needed and the color to green

Then I set "MODA Center event (info only) AND operation order - no ops order needed to purple, they both end up green. What else can I do to make sure things have different colors on the calendar?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!