Automotion with condition containing wildcards

Options
MattFerfecki
MattFerfecki ✭✭
edited 03/23/22 in Smartsheet Basics

I'm looking for automation changing a value in a given cell based on the email provided in another one.

Literally,

if the email provided in Cell_1 bellongs to the domain "@domainAAA.com", Cell_2 should change to AAA.

If the email belongs to the domain "*@domainBBB.com then Cell_2 should change to BBB.

I am wondering how I should provide the condition combining it with the wildcards.


Matt


Answers