How do I color code a record that is on the Calendar Report based on a value?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Where would I add the formula so that the color coding would work on the calendar?

I want something like this:

If([Probation]="Yes",Red

If([Overtime Issued]="Yes",Green
Photo of Marc Nelson

Marc Nelson

  • 342 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
You will have to make a new field to show on the Calendar report

Check out this help link

https://help.quickbase.com/user-assistance/color_field.html

If you do not want to write any code at all, look for my post in this thread here.  It could work if your drop down choices were from a relationship as opposed to a simple multiple choice field.

https://community.quickbase.com/quickbase/topics/december-2017-release-notes-new-ui-coming