Need a help to resolve issue get formula

Hi ,

can I get a help to resolve below issue. From below table i want to get data in such a manner. if column 2 is blank then I want to get data from 3 column other wise from column 1.

And I tried below formula but it does not work

IF ISNULL([COLUMN2])THEN[COLUMN3] OTHERWISE[COLUMN1] endif.

1	2	3
ab	ad	ca
	ma
cd
		tb
cb		dk

Thanks

Rojan

Tips and Tricks

Accepted answers

HomesickSurfer

Hi @rojan

This updates [2] in priority of [2],[3],[1] if neither null nor empty.

IF 
!IsEmpty([2]) OR !IsNull([2]) THEN [2] 
ELSEIF 
IsEmpty([2]) OR IsNull([2]) AND IsEmpty([3]) OR IsNull([3]) THEN [1] 
ELSEIF 
IsEmpty([2]) OR IsNull([2]) AND !IsEmpty([3]) OR !IsNull([3]) THEN [3]
ELSE [2] ENDIF

atcodedog05

Hi @rojan

Is this what you are looking for. Groupby and sum.

Hope this helps : )

summarize.yxmd

All comments

atcodedog05

Hi @rojan

Here is how you can do it.

Workflow:

Hope this helps : )

Formula.yxmd

rojan

HI,

if COLUMN 1 , 2, 3 data have i i want to pick up from column 2. and in above formula its data capturing column 3

atcodedog05

Hi @rojan

Check this one out.

Workflow:

Hope this helps : )

Formula.yxmd

apathetichell

@rojanyour original formula said that if column 2 was blank you wanted column 1 - else you wanted column 3. Column 2 data was not captured in either scenarios. If this isn't the case - what do you want?

HomesickSurfer

Hi @rojan

This updates [2] in priority of [2],[3],[1] if neither null nor empty.

IF 
!IsEmpty([2]) OR !IsNull([2]) THEN [2] 
ELSEIF 
IsEmpty([2]) OR IsNull([2]) AND IsEmpty([3]) OR IsNull([3]) THEN [1] 
ELSEIF 
IsEmpty([2]) OR IsNull([2]) AND !IsEmpty([3]) OR !IsNull([3]) THEN [3]
ELSE [2] ENDIF

atcodedog05

Hi @HomesickSurfer

Just an info share IsEmpty() also covers IsNull() 🙂

Good catch on the priority order 🙂👍

rojan

Thanks for below solution and its working!

One more question if I want to make new column based on below input .

input column

a	10
a	10
a	10
b	30
b	30
b	30
c	20
c	20
c	20

desired output

a	30
b	90
c	60

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703