If Sample Number Contains THEN "" ELSEIF "Original Word as "Alpha OR BETA"

[Franzil]

Dear Team,

I hope this message finds you well.

I am seeking assistance with a workflow adjustment. Specifically, I need to identify all sample numbers that begin with 76, 77, 74, and 71, and update them to "FR" in the Bucket column. Depending on the current designation in the Bucket column, these should be labeled as "FR ALPHA" or "FR BETA." If the specified conditions are not met, the entries should remain unchanged as "ALPHA" or "BETA."

I would greatly appreciate any guidance or support you can provide on this matter.

Thank you in advance for your assistance.

Best regards,

Franzil

[flying008 · Accepted solution]

Hi, @Franzil 

FYI.

IIF(Left(ToString([Sample]), 2) in ('71','74','76', '77'), 'FR ' + [Bucket], [Bucket])

[Franzil]

Hi, @flying008 

This is awesome! It works, thank you so much for the help. Godspeed.