#CONTACT EXPECTED

Options

Hi All, I am trying to make smth in Smartsheet work; tried everything but it doesn't work. In a sheet summary, I am trying to count how many times a name appears in a Contact list column. I use following formula: =COUNTIF(Owner:Owner, "name@email.com") but it throughs following error message: #CONTACT EXPECTED. I also tried with the Name instead of the email. I suppose it's smth with the Contact column as the same works fine with Text/Number columns. Would you have an idea how to make it work?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!