Skip to main content
Question

Calendar Coding

  • September 15, 2020
  • 0 replies
  • 23 views
I would like to color code a calendar report I made but I can't seem to wrap my brain around the formula, can anyone here help me?

I have the calendar report set up to display the [Project Name], in the record I have fields [Status] and [Preparer] and I would like the calendar report to show the [Project Name] in hex color #d95959 if the [Status] field is blank but the [Preparer] name is not blank AND not the user​.

------------------------------
Brianne Jacobsen
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Quickbase Alumni
  • September 15, 2020
For something like this, I would suggest a formula along these lines:

IF([Status]="" AND (UserToName([Preparer])<>"" AND User()<>[Preparer]),"#d95959")​

------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
Terms & ConditionsAccessibility statement