How to write if condition on multiple is not empty fields in formula tool

Hi,

I have 3 fields(CA1,CA2,CA3) as below . I need output as 1.SMITH, 2.ROCH, 3.HEALTH for not empty columns and for empty columns I want it as 1.KIN in my target column TEXT.

CA1	CA2	CA3
KIN
SMITH	ROCH	HEALTH
KIN	BRIDGE
KIN	AMERI
MORGAN	KIN	CARE

Target :

TEXT

1.KIN

1.SMITH, 2.ROCH, 3.HEALTH

1.KIN, 2.BRIDGE

Please help me to get the result.

Below is the condition I am using in formula tool for all three non empty columns but I am getting null() in my output.

If (! Is Empty ([CA1]) and ! Is Empty ([CA2]) and ! Is Empty([CA3]))
then "1."+[CA1]+"2."+[CA2]+"3."+[CA3]
else null()
endif

Developer Tools

Accepted answers

atcodedog05

Hi @swethav

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

text.yxmd

All comments

atcodedog05

Hi @swethav

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

text.yxmd

atcodedog05

Happy to help 🙂 @swethav

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂

swethav

I want five years back date . Date value is 2023-06-18 . I want five years back date . By using below I am getting only year .

Please help me

atcodedog05

Hi @swethav

remove tonumber() function and datatype should be date or string.

datetimeadd([Cuccess],-5,'year')

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167