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?
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.
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.
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.