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

Answers

  • Athar
    Athar ✭✭

    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.

    · 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!