Count If Unique

Options

Melissa Erskine

Melissa Erskine ✭

11/17/21 in Formulas and Functions

Hi!

I'm trying to figure out how to do a Count If Unique formula in Smartsheet. I know I can use the Distinct function in replace of the Unique function, but I need it to Count a specific criteria from another column?

Thanks! Melissa

Tags:

Formulas

0 ·

Answers

Parker Oxford ✭✭✭✭✭

11/17/21
Options
This discussion may be useful for this.
( @ me in the replies or I'll lose your message! )

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

I am trying to get the percentile of responses that return "1-2" if the responded "4 Months" in
I am trying to get the percentile of responses that return "1-2" in a column if the response is "4 Months" in another column. =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, "4 Months", 0.5)) or =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, {Survey Time}, "4 Months", 0.5))…
COUNTIF where counting if cell contains "Super" but "Superstar"
I have a formula where I'm counting how many products are at a certain status and where they have a title of Super, Super & more or Super & Design (B&W) - but want to make it scalable. Is there a way to create a formula where I can tell it to count any cell where "Super" is the prefix? And secondarily, not count anything…
COUNTIFS with multiple OR dates
Im trying to use a formula that counts the number of projects where it fulfills certain criteria that then checks whether the startdate was after a beginning date range or the end date was before the end date range. (basically that work was performed within the date range). This is what I have: =COUNTIFS({Marcom Portfolio…