Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 16, 2023 10:13 AM
Hi!
I'm having such a basic issue and can't figure out what I'm missing.
I believe this should be a very basic IF statement: IF {field} is not empty, show this stuff. However, I've tried using {field}, {field}!="" and {field}!=BLANK() and even where there is nothing in {field}, text is showing.
Here's the simplified formula I'm using to figure out what is going on (substituting "the text" for what will really be there):
Solved! Go to Solution.
Feb 17, 2023 09:26 AM
Okay! I figured this out. I didn't need !=BLANK() or !="", just using IF({field}) is enough, BUT the field it was pulling in had line breaks in it, which i couldn't see in the output. So it was always showing something because there WAS something!
Feb 16, 2023 10:23 AM - edited Feb 16, 2023 10:27 AM
Your formula as written is basically saying, if the {abr formula- all} field exists (which it does regardless of whether or not it's empty), return "the text".
I believe you want one of these two options:
IF({abr formula- all}=BLANK(),"","the text")
IF(NOT({abr formula- all}=BLANK()),"the text","") #more complicated but can be useful in certain situations
Feb 16, 2023 11:01 AM
Hmm.. I haven't had to do that in the past, and my understanding was that if you use IF and {field} it's actually checking for a value there?
Feb 16, 2023 11:11 AM
Here's an example where it works as I've done it this way (with an extra AND)
Feb 16, 2023 11:50 AM
It also seems to work sometimes?IF({abr formula- all}!=BLANK(),{abr formula- all})But if I put "the text" in there, it always shows a value.
Feb 16, 2023 11:58 AM
When you write IF({abr formula- all}!=BLANK(),{abr formula- all}), you're saying if the original field is not blank, infill the new field with the text from the original field.
Feb 17, 2023 09:26 AM
Okay! I figured this out. I didn't need !=BLANK() or !="", just using IF({field}) is enough, BUT the field it was pulling in had line breaks in it, which i couldn't see in the output. So it was always showing something because there WAS something!