Smartsheet formula to find similar email on a cell


Hey there folks!

I have a form that people fill in to request a donation match for my company. So, each request is a row on my sheet.

How can I crate a formula that indicates if one e-mail/contact has already placed a request?

I´d need something like this to appear on a cell: "1st Donation Request" (if the contact on my sheet appears the first time) or "Additional Request Placed" (if the contact is already on my sheet).

Thanks for the help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!