Dec 29, 2023 02:58 AM
I 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")
Solved! Go to Solution.
Dec 29, 2023 05:14 AM
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")
Dec 29, 2023 04:44 AM
Hello @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.
👍
Dec 29, 2023 05:14 AM
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")
Dec 30, 2023 08:42 AM
You 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.
Jan 10, 2024 07:42 AM
I 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!
Jan 12, 2024 01:32 PM
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}