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
Solved! Go to Solution.
if [custom value 5] = 'None, None'
then 'None'
else [custom value 5]
endif
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
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
Thanks!