Hello,
Could you kindly help me create this formula. If Work Region2 is empty and SCL SID is equal to "R559485", "B569945" then Work Region2 should say "Onshore - Intl Sales".
Thank you in advance.
Work Region2 | SCL SID |
Onshore - Intl Sales | |
R559485 | |
B569945 | |
Offshore - Intl Sales |
Solved! Go to Solution.
Hi @Gaetano_B
Use this use formula on Work Region2
IF IsEmpty(Trim([Work Region2]," ")) AND
[SCL SID] in ("R559485", "B569945")
THEN "Onshore - Intl Sales"
ELSE [Work Region2] ENDIF
Like below:
IsEmpty() checks both nulls and blanks
Input:
Output:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @Gaetano_B,
Thank you for your question to the Community!
I moved your post to the Designer Discussions forum there you can ask anything technical about Designer. This article "Q&A: Where Do I Post My Questions?" should also help you out.
If this @atcodedog05 's post helped you please mark it as solution.
Thank you!
Let us know if you need any help!
Cheers,