Help with Countif function

swoodring80171

swoodring80171 ✭✭

07/08/21 in Formulas and Functions

I am new to Smartsheets. I am trying to write a formula that will count a cell in a row called achiever if it is a 1,2,3,4 or 5. Can someone help me?

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

07/08/21

Are you able to provide a screenshot of the source data as a reference?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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

Formula countif
Hallo Can you check what i need to do to change the formula . Example When i use formul =COUNTIF([Column2]:[Column2]; [Column2]@row) Then when cell in location is emty ( which is always empty ) then it is i always get total numer of cels … Can someone help me to make formul to make sure this doesnt count emty field into…
If Statement Help
I could really use some help! I am trying to write an if statement. Based on: Due date being < = -68 New entry is "starred" Entry 1 = "yes". I want it to be complete if it meets the conditions listed above and incomplete if it doesn't meet those conditions. This is what I tried: =IF([New Entry]@row = 1, [Entry 1]@row,…
Countifs, with a cross reference and an or
Hi there, I'm trying to count how many red risks I have in my RAAIDD log that are not closed or complete. I've written the below, but I can't get it to work. Any advice would be gratefully received, please. =COUNTIFS({NAME RAAIDD Range 1}, "Risk", {NAME RAAIDD Range 3}, ">=8", {NAME RAAIDD Status}, OR(@cell = "Open", @cell…