Unparseable Message on Column Formula
I can't get this formula to work in my spreadsheet, any suggestions on how to fix it?
=countif([Column5]@row11:[Column16]@row11, "*"&[Column17]$10&"*")
Best Answer

It looks like you are trying to count how many cells between [Column5] and [Column16] (on each row) contains the value in [Column17]$10. Is that correct?
Answers

It looks like you are trying to count how many cells between [Column5] and [Column16] (on each row) contains the value in [Column17]$10. Is that correct?

Yes!

Formula syntax between Excel and Smartsheet isn't always compatible. Give this a try:
=COUNTIFS([Column5]@row:[Column16]@row, CONTAINS([Column17]$10, @cell))

That worked!! Thank you!!

Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!