Hi All, I have such a basic ask, but i am struggling to write the correct formula. I have two columns, i am trying to write a simple formula that does the following ; if column A is "blank" & column B is "not blank", then populate Column A with column B Then Remove value from Column B Input Column A Column B 123 High Street Expected Outcome Column A Column B 123 High Street I have used the following formula ; If isnull([Column A]) then [Column B] else [Column A] endif Current output Column A Column B123 High Street123 High Street

IF formula when column A is Blank, populate with Column B, update column B With blank

Masond3

Hi All,

I have such a basic ask, but i am struggling to write the correct formula.

I have two columns, i am trying to write a simple formula that does the following ;

if column A is "blank" & column B is "not blank", then populate Column A with column B

Then Remove value from Column B

Input

Column A	Column B
	123 High Street

Expected Outcome

Column A	Column B
123 High Street

I have used the following formula ;

If isnull([Column A]) then [Column B] else [Column A] endif

Current output

Column A	Column B
123 High Street	123 High Street

Common Use Cases

Accepted answers

Christina_H

You can use AND / OR in formulas to extend the logic. An exclamation mark can be used for NOT.

IF [Column C]="New York" AND IsEmpty([Column A]) AND !IsEmpty([Column B]) THEN [Column B] ELSE [Column A] ENDIF

All comments

DataNath

Hey @Masond3, you can just add a second expression like so that will empty out (null) the second column. Input:

Output:

Populate column 1 with column 2 then emtpy.yxmd

Masond3

@DataNath That would populate for anything in column B, is there a way it can only populate for those records in expression 1 ?

binu_acs

@Masond3 One way of doing this by assigning the value of B to a temporary variable

Update_270223.yxmd

Christina_H

Simplest way would be to clear column B if it's the same as column A after the first formula.

IF [Column B]=[Column A] THEN Null() ELSE [Column B] ENDIF

Masond3

Hi @Christina_H - that makes sense

Daft question, if i want to apply the formula to only work in x circumstances ( how do i apply more logic)
example
if column c = New york,

and column A is "blank" & column B is "not blank", then populate Column A with column B

Then Remove value from Column B

Christina_H

You can use AND / OR in formulas to extend the logic. An exclamation mark can be used for NOT.

IF [Column C]="New York" AND IsEmpty([Column A]) AND !IsEmpty([Column B]) THEN [Column B] ELSE [Column A] ENDIF

Masond3

@Christina_H Super Star ! hopefully this help me some of the issues i am encountering

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703