Forum Discussion

BrianneJacobsen's avatar
BrianneJacobsen
Qrew Trainee
5 years ago

Calendar Coding

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
------------------------------
Formulas and functions
reports and charts
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    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
    ------------------------------