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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!