Thank you, That was totally messing me up. It worked sometimes and not others (!=). I figured I had something else wrong and been spinning around on that.
I’ve changed my formula to just be = BLANK. Now I’m stuck on something else. Basically I have 10 columns. I need to evaluate each column, if it is BLANK return “”; if it is not blank return ", " and the field. In the end I’ll have all the columns concatenated into a complete Source for a bibliography.
If anyone can point me to an example of something like that; I could try to mimic.
If finally understand what you are talking about. I kept thinking about it and I didn’t get it. It’s because I have () after Blank, so ) closes the condition and my TRUE is return Creator & X. Got it now.
I see where I got confused about it. In the Formula field reference guide if you search on BLANK
BLANK() Returns a blank value. IF(Price > 1000000, BLANK(), “Wow, that’s pretty expensive”)
Since that formula has BLANK(), I thought you must have to use () after Blank all the time.