Multiple email contacts in the IF statement



I have custom contact list column, which displays email contacts based on the conditions.

Here's an example of that column:

=IF(AND([Column1]@row = "Value1", OR([Column2]@row = "Value2", [Column2]@row = "Value3")), ",,", IF(AND([Column1]@row = "Value5", OR([Column2]@row = "Value7", [Column2]@row = "Value8")), ",",

This is just a part of the code, but the column displays the emails based on the condition, however the notification we have set up to be send to that column is not going out. I have tried it as well on test environment with just mine and my colleague emails, and I haven't receive the notification. Is there any workaround for that?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!