=COUNT(DISTINCT(COLLECT

Options

Hi,

i am using the "DISTINCT" value in a formula which works great however is there a way to not count entries twice based on if its submitted as capital or lower case, for instance 'Fred' & 'fred' are counted as two unique names when in fact i only want it counted once?

Cheers

Shaun

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!