Forum Discussion

KellyLyons1's avatar
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

  • Email is treated like text so: 

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

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

    Chayce Duncan