Need Formula to Count unique ID's that are all approved

MJ215

MJ215 ✭✭

10/04/21 in Formulas and Functions

0 ·

Answers

Athar ✭✭

10/04/21

You may use COUNTIF Formula in Sheet Summary as given below:
=COUNTIF([Approved or Pending]:[Approved or Pending], "Approved")

Note:
If this works, please accept this answer by clicking on "Yes" so others can get help from same.

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

SUMIF sum of the number of cells meeting a text condition
I'd like to add up the number of boxes with the same condition. For example, in column 1 I would like to count how many times I have the word nature. When I use SUMIF to do this it doesn't works.
Date Formula Issues, Metric sheet
I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically updates as I add and delete years from my main sheet. What formula would I use for that part as well? I've tried a few…
Formula to match data from one sheet to another, then calculate the total if a different column true
STUCK in Formula H_ll! lol I'm terrible at formulas and trying to learn! I need your help PLEASE! I have a Master sheet where everyone places orders, it contains the an account number to be charged to and total for each order as well as the status of each order, in a separate sheet I have all of the account numbers. In the…