Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Conditional formatting - Calendar view

image.png

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

image.png

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!

Trending in Formulas and Functions