IF formula with Contact List and Automation

Can you use a Contact List in an IF statement and take advantage of Automation?

For example in ColumnB (contact list):

=IF(ColumnA@row = "Summer", "Firstname Lastname ([email protected])")

then use Automation to Alert someone when their name appears in ColumnB.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!