Is Null formula

[vsalver]

Is this formula correct? if there is null in A it is not replacing with the B value. Please help

If IsNull([A]) then [B] else [A] endif

[jdunkerley79]

Yes that is a correct formula to replace nulls with B

Are you getting an error message? If so can you post a screenshot?

[vsalver]

No error message, just the desired results are not coming

[jdunkerley79 · Accepted solution]

Could you post your workflow or some sample data to look at?

At a guess if A is a string field you might want IsEmpty if meaning to replace ‘’ as well as NULL.

[AshwiniChezhiyan]

It is possible that you are not getting the desired results as your main column contains whitespaces. Try using Data Cleasing Tool to clear the field off any redundant spaces before inserting the formula.

Also, are you input fields String or others? IsNULL works on both string and numbers, so type may not be an factor

[vsalver]

IsEmpty worked for me, thanks