The formula function “when_empty” will return the first argument, even when it is an empty string. Am I using this function improperly? If so, what is the proper use case of this function?
I wanted to be able to do something like this:
if(isblank(firstArgument), secondArgument, firstArgument)
but, without having to write the first argument twice. That is how I expected when_empty to work based on its description.