Sheet Summary formula not working

Christina Riot
Christina Riot ✭✭✭✭
in Formulas and Functions

Any ideas as to why this formula isn't working?

=COUNTIF([Return- boundaries between works areasο»Ώ]:[Return- boundaries between works areasο»Ώ], "Very Important")


I coped the column name from the actual column as to not misspell anything etc. Then I tried typing it out thinking maybe the copy and paste went screwy. Nothing works. No matter what I do i get unparseable.

· Share on FacebookShare on Twitter

Answers

  • Kelly Moore
    Kelly Moore Community Champion

    Hi Christina

    I copied your formula into a sheet. I copied your column name exactly. I made sure the "Very Important" cell data was exact. Your formula worked perfectly. The column type I put the formula in was a Text/Number column.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!