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.

How can I change the color on the calendar by employee name?

Example:

I have a task name, audience and name of responsible Party in my grid view, if I change to calendar view I want to see the task name by color on the calendar. For example:

Career is the task name and responsible party is Jackie

Goal setting is the task name and responsible party is Vicki

When I look at the calendar I want to see Career in yellow (Jackie) and blue for Goal setting (Vicki)

As these could be on the same day I want to be able to tell the task belongs to by the responsible party by color.

Thanks,

Connie

Connie Roundcount

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions