+15I just realised this simple formula, on most fields does not work . Test was done on a Single-Line field.
IF(test1 != BLANK(), "Not Blank", "Blank")
IF(Not(test1 = BLANK()), "Not Blank", "Blank")
Best answer by Sho
In formula fields, I want the formula to be simple, so this is how I do my field checks.
IF({test1}, "Not Blank", "Blank")
IF(NOT({test1}), "Blank", "Not Blank")
+23Hello @Karl_at_Easy_La
I think this will be a basic formula for it.
IF(Name=BLANK(), "Blank", "Not Blank")Check the Image as well.
I hope it helps.
👍
In formula fields, I want the formula to be simple, so this is how I do my field checks.
IF({test1}, "Not Blank", "Blank")
IF(NOT({test1}), "Blank", "Not Blank")
+25You can also do
IF(Name, 'Not Blank')the default for third IF parameter is blank value, so it just output nothing when {Name} is empty. For one word field names figure brackets can be omitted.
+15I just realised the issue is with Lookup-type fields that give the most problems. For those, = Blank() doesn't work as expected. I'll use one of these proposed solutions, thanks!
+25I just realised the issue is with Lookup-type fields that give the most problems. For those, = Blank() doesn't work as expected. I'll use one of these proposed solutions, thanks!
You can experience problems using other functions with Lookup-type fields. To prevent it, convert array to string by adding empty string. Instead of {Field} use CONCATENATE({Field}) or ""&{Field}
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.