Substitution not checking for published?

I am substituting a field in a user list with [cb:if]. For that I am checking if the field is empty [cb:if cb_field != ""].
This works.
However when the field is not published, it still displays the substituted value in the user list.
What is the approach not only to check if the field is empty but also to check if it is published and not showing the substituted value when it is not published.

Raw substitutions don't care about a fields published state. They'll never check for that, because it's just directly checking the raw database value. Simply don't try to substitute in a field you don't intend to publish. If you mean the field still displays in a userlist column even though the field has been unpublished that's a result of the below bug which is only checking published state on select when configuring the userlist.

forge.joomlapolis.com/issues/6654

You'll need to remove the field from the userlist to prevent it from displaying until the above bug is fixed.