Skip to main content
Question

If Email is blank formula help

  • March 4, 2024
  • 0 replies
  • 86 views
Forum|alt.badge.img+7

I am trying to highlight the email address field in reports if it is blank.  I have tried

If(IsNull([Email]), "#ffffba"))  but it is not working, I am getting a syntax error.  Do I need to convert the field to a text field 1st and then use the formula?

Any suggestions??



------------------------------
Kelly Lyons
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Quickbase Alumni
    • March 4, 2024

    Email is treated like text so: 

    if( Trim([Email]) = "", "ffffba", "")

    Trim just helps make sure you don't have any misleading spaces



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement