Discussions

Expand all | Collapse all

Calendar Coding

  • 1.  Calendar Coding

    Posted 13 days ago
    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
    ------------------------------


  • 2.  RE: Calendar Coding

    Posted 13 days 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
    ------------------------------