Sheet Summary formula not working

Options

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.

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!