Forum Discussion
EvanMartinez
8 years agoModerator
Hi Robert,
It is possible to color not just the beginning and ending day of an event but the entire event entry on a calendar. You would do this using the option within the calendar report settings for Color-Coding. Once you check that checkbox you can create a formula to colorize your calendar to reflect certain criteria. For example all projects in progress should be green, all projects delayed should be yellow, etc. That way the full entry will be colorized. You would use a formula like the one below to set your conditions for each color of the calendar.
It is possible to color not just the beginning and ending day of an event but the entire event entry on a calendar. You would do this using the option within the calendar report settings for Color-Coding. Once you check that checkbox you can create a formula to colorize your calendar to reflect certain criteria. For example all projects in progress should be green, all projects delayed should be yellow, etc. That way the full entry will be colorized. You would use a formula like the one below to set your conditions for each color of the calendar.
var Text Status=[Status];This way the end result gets you a calendar where the full entry is colored matching your coding. Is this roughly what you were looking to accomplish?
If($Source="Under Review", "#347235",
If($Source="In Progress","#CA226B",
If($Source="On Hold", "#FF8C69",
If($Status="Planning Stage", "#8E388E",
If($Status="Completed", "#76EEC6",
If($Status="Cancelled", "#77BFC7"
))))))