countif(distinct(

Options

=COUNTIF(DISTINCT({Case Consultation Tracker Advisor Namex}, {Case Consultation Tracker Advisor Namex}, {Case Consultation Tracker Meeting Number}, =1))

Trying to count Avisor Namex if the same is unique AND Meeting Number is 1. Coming back with INCORRECT ARGUMENT.

Help needed.

Lisa

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @lisalettieri

    Just to clarify that this was the formula you tried with Collect:

    =COUNT(DISTINCT(COLLECT({Case Consultation Tracker Advisor Namex},{Case Consultation Tracker Meeting Number}, =1)))

    Does this work for you?

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!