Not sure why this formula is not working


Hi all,

I have this issue where I'm trying to have Smartsheet automatically respond no to a column if the same person was requested before and said no already. IF they said no, the row would copy itself to the bottom and replace the one that said no's info with the next one requested. Thats where I would like smartsheets to automatically say no on behalf of the next one requested if they were the same person as before. One part of the formula I am trying to build will check the event number and the email to see if they are more than 1 and if they are then to check a box. the formula looks like this.

However, it is saying no match when the event numbers are the same and the emails are the same. I am not sure what is wrong with the formula. Any advice would be helpful. Thanks!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!