Sign in to submit new ideas and vote
Get Started

Add Count Unique function

Please add a COUNTUNIQUE function (or COUNTU for short). It's a pretty self explanatory and similar to other COUNT functions.

My intent is to have an automatic Project ID number that is based on the unique project title and I can have multiple entries of the same project title without the ID changing.

There is a work around but not very elegant. By adding a helper column that will count all the items in the column in question that match the item in question in the current row and have earlier created dates, and then report ZERO if there are earlier matching rows or ONE if not. Then simply sum that column.

However, adding new functions to Smartsheets does not break any existing workflows, equations, reports, etc. It just means the hard work of proper documentation (ahhh, the life of professional app developers:).

2 votes

Idea Submitted · Last Updated