You can add a calculated field that will do the trick: IF(
ISBLANK({DE:customFieldName}) || {DE:customFieldName} = "" || {DE:customFieldName} = "N/A",
"Character Limit is 100 Characters",
IF(
LEN({DE:customFieldName}) > 100,
" Exceeding Limit of 100 Characters",
...