identify whether a cell or text field is blank
Use this formula:
IF(LEN({Column Name}) > 0, “Not Blank”, “Blank”)