Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
13 days ago

Checking For Null Field on Text Field?

I have the following formula that checks a date field to see if it is null:  If(not IsNull([Coaching_Pipline_Date]), "You have been counseled prior to this conversation on", null)

I would like to do this same thing, but change the field to be checked to a text field as when I try to change the field in the formula I get the error :

How would I write this to check a text field type?

Thanks  Brian

  • I'm not quite sure what you're asking, but if you're trying to ask how to check if a text field is blank then you do it like this

    IF([my text field] ="",  ..........