itsnotbroken ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error.  

Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken.  Right now, the only thing in the cell is "=COUNT([Task Name]:[Task Name])"

All that is doing is counting all cells with any data in them. [Task Name] is the primary column. This formula is in a column with text/number format. 

Any ideas?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!