Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I have a list of project numbers that I need to count, the issue is that the different people may be working on different areas of the same project so duplicates need to be automatically excluded.
Are you trying to count the names or the project numbers?
Hello,
There isn't built in functionality to identify or exclude duplicates. See this community post from January where another Community member has posted a workaround using a formula: https://community.smartsheet.com/discussion/identifying-duplicates-with…
Check out this article from our Help Center for more information on creating formulas: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet
A listing of all available Smartsheet functions can be found here: https://help.smartsheet.com/functions
When you have a moment, please submit a product enhancement request to let our Product team know that you'd like the ability to automatically identify duplicates on a sheet. The product enhancement request form is located in the Quick Links section to the right of this discussion.
The subject of getting a count of entries excluding duplicates has been coming up a lot lately.
The first link in Corrine's post here is only a way to identify duplicates. It sounds like you are looking more for a way to identify them and count only one entry of a duplicate plus the unique entries.
Here is a link to another post that should help you with this.
https://community.smartsheet.com/discussion/count-unique-words
If you look at my comment on that post, you will see another link with a different variation of the same.
If you can give more details, I may be able to help with a more specific solution to your case.
I have a 6 column, 10,000+ row sheet that feeds into other sheets of data through vlookup formulas, that I update on a weekly basis with new information from an outside source. the columns stay the same but the row #'s vary. is there a way I can upload the new excel version of the data to automatically upload the existing…
Is anyone else experiencing this issue today (7/28/2026)? Every time an automated email triggers on its own today, whether it's a regular alert, update request, etc, the values that usually appear when the automation workflow includes a field in curly brackets (ex: {{First Name}}) appears as a weird alphanumeric value in…
Hi - Is anyone else having problems with placeholder fields in update request automations today? I've been notified by my staff that our automations today are showing random text strings instead of the field data that they are supposed to. For example, in one of my sheets, there's an automations thatis supposed to show a…
