Forum Discussion

KellyLyons1's avatar
KellyLyons1
Qrew Trainee
3 months ago

If Email is blank formula help

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
------------------------------

1 Reply

Sort By
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    3 months ago

    Email is treated like text so: 

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

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



    ------------------------------
    Chayce Duncan
    ------------------------------