Formula question

Hello I'm trying to create a statement in a formula tool that takes 3 different columns and if a cell says None, None I would just like it to say None, instead of just saying None, None.

I tried to write a statement like this but it obviously didn't work.

If [Custom Value 5], [Custom Value 6], [Custom Value 7] = None, None THEN ELSE set to 'None' ENDIF

See screenshot for an example

Alteryx_Question_1.JPG

Developer

Accepted answers

Robin_McIntosh

if [custom value 5] = 'None, None'

then 'None'

else [custom value 5]

endif

All comments

Robin_McIntosh

if [custom value 5] = 'None, None'

then 'None'

else [custom value 5]

endif

IraWatt

Hey @Sjkitts,

One way to apply this to multiple columns is using the multi field formula tool:

you cant reference multiple fields in one formula like "[Custom Value 5], [Custom Value 6], [Custom Value 7]" also you need to add quotes None, None as its text.

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

Robin_McIntosh

Sicne you are concatenating 3 columns, would there ever be None, None, None? If so, then just update the formula as:

if [custom value 5] in('None, None', 'None,None,None')

then 'None'

else [custom value 5]

endif

Sjkitts

Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703