COUNTIF imparsable

Kerri

Kerri ✭✭

02/09/22 in Formulas and Functions

I'm using the below formula in a Sheet Summary field to calculate how many rows have a value over .7. It keeps coming back as imparsable. Any ideas?

=countif([Device1]:[Device1]), >.7)

0 ·

Answers

Sameer Karkhanis ✭✭✭✭✭✭

02/10/22
There is a syntax error in the formula, try below
=COUNTIF([Device1]:[Device1],>0.7)
0 · Share on Facebook Share 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!

Trending in Formulas and Functions

Workday is not omitting the holidays?
I have tested this manually, as well as outside of my formulas. I want to reference a date, and then search on the Holidays range (a list of holidays) and return the previous workday if the date is found in the holiday list. The formula ALWAYS returns the day before the date, whether it's in the holiday list or not. Any…
I want to send automated email to "assigned to", from a sheet, but only one reminder email vs mutlip
I have title, "assigned to" column, status(task 1), due date (task 1) columns, status(task 2), due date(task 2)…it goes for at least 10 tasks. The conditions to trigger the emails are, trigger 2 days before due date(when status is not equal to completed) and leave weekends trigger on due date(when status is not equal to…
Conditional formatting for "where % complete is not equal to 1" is not working
I have a project plan where I'm trying to set conditional formatting where % Complete is not equal to 1 and Finish Date is in the past, to turn row Yellow. It is not working. Please advise.