Take values from 1 column if the other is blank

[premkav]

Hi Team

I would like to have values in column C updated from column A. If A is blank, then take values from B, else retain A

In the formula tool how do I update it? My excel has =IF(A="",B,A)

[pedrodrfaria]

Hi @premkav 

Just need to use the Formula tool to create/update the Column C with a function

"If isnull([Column A]) then [ColumnB] else [ColumnA] endif"  

Or maybe this one:

"If isempty([Column A]) then [ColumnB] else [ColumnA] endif"

Pedro.

[premkav]

Thanks @pedrodrfaria 

I just tried the formula, but for some reason I cannot see the values

Do you know why this is so?

Regards,

premkav

[premkav · Accepted solution]

Thanks @pedrodrfaria 

I got the solution

Regards,

premkav