Forum Discussion

Qrew Cadet

4 years ago

Formula Assistance - Field is null or not null

I have a field called PHI that I want to populate based on data in another field called Data Elements which is a multi-select field. Ideally I would like the PHI field to be a checkbox but it could ...

Formulas and functions

BlakeHarrison

Qrew Captain

The easiest would be to do a checkbox formula field. You could do this simply as:

ToText([Data Elements])=""

Since the only options are True or False, you don't actually have to use a full IF/Then/Else setup, you can just identify the criteria that would create a True statement.

------------------------------
Blake Harrison
bharrison@datablender.io
/
------------------------------

RachelMiller

Qrew Cadet

4 years ago

Thank you so much Blake!

Rachel