Simple formula

[Gaetano_B]

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

[atcodedog05 · Accepted 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 😀👍

[StephV]

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,

[atcodedog05]

Happy to help 🙂 @Gaetano_B 

Cheers and Happy Analyzing 😀