Checking For Null Field on Text Field?

Question

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

MarkShnierYou · Answer

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 thisIF([my text field] ="",  ..........

Sign up

Login to the community