Count of Unique Participants in a Time Range

Options

Hello,

I am attempting to write a formula for this sheet that counts the total numbers of unique patient ID within a date range (7/1/20-6/30/21) from the "date of CM" column. Anyone know how to do that? I keep getting an error message.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!