Formula if TEXT column has characters or not

Platform discussions
, ,
1

I’m trying to make a simple formula that if there are characters in a TEXT Column give me a number of “1” as the response, but if the TEXT column cell blank then return a response that is empty. I tried this:

IF({Workaround Description}=“”, “”)

and it returns the word “true” when I want a number 1…the blank part is working.

image

Update…I got the “1” part working but if the TEXT cell is empty i want it to remain empty but its showing the word True???

IF({Workaround Description}<>“”,“1”)
image

Update - looks like this formula works…any have a better way?

IF({Workaround Description}<>“”,“1”,“”)
image

Thanks for the help…