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."
@flying008 already solved this by creating a formula below and thanks to that however, In any chance, is there a way to get a the same output without using a hard code or a formula tool?
IIF(Left(ToString([Sample]), 2) in ('71','74','76', '77'), 'FR ' + [Bucket], [Bucket])
I would greatly appreciate any guidance or support you can provide on this matter.
Thank you in advance for your assistance.
Best regards,
Franzil
