Hi @gavinloi,
this is the formula that you need to use:
IIF(IsNull([B]), [A], [B])
Please see the workflow attached.
Hi @gavinloi
This can easily achieved by formula tool.
Input:
Workflow & output:
The formula needs to applied on Column B (Target column). IsEmpty() checks whether the column is Null or blank. IIF() is a if else condition if column B is empty then column B else remain unchanged and keep column B.
Hope this helps 🙂
Many thanks! It works 😀
Many thanks!😀