Hi all,
I want to fill the null entries under family account (tier 1) with the respective sold-to account (tier 2). However, I am facing below problem with my IF formula:
Applied formula: IF IsEmpty([Family Account]) THEN [Sold-to account] ELSE [Family account] ENDIF
Problem: Formula is adding an additional family account entry under sold to:
Before:
Parent account
AB
Sold-to account
BB
Outcome:
Parent Account
AB
Sold-to account
BB
AB
Are you able to help me on this please?
Thanks
Solved! Go to Solution.
Hey @LM_APAC2023
Would you be able to share your workflow or a representative equivalent if it contains sensitive information?
If it still doesn't resolve make this adjustment
IF IsEmpty(Trim([Family Account])) or IsNull(Trim([Family Account])) THEN [Sold-to account] ELSE [Family account] ENDIF
Thanks a lot, Bolide!
This has done the trick.