When using a IF function and you wanted to return the original value in the field if the formula didn't return anything what would need to be entered?

_$ comes to mind but I'm not 100% sure.

Hi Julie,

You can use $_ to return the original value of the field, or you can reference the column name. Note: what you are asking will only apply if you are using a value override of the original column value.

Seth

{$_} is the self-reference operator.

Example of an in-place value override:

Application Family = If({$_} = "Business Apps", "BA", {$_})

It's a useful shortcut, but you can also use the full column name instead:

Application Family = If(Application Family = "Business Apps", "BA", Application Family)