Formula question

[Sjkitts]

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

[Robin_McIntosh · Accepted solution]

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

[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!