-
Multiple Condition Duplicate Line
Hello, I am creating a tracking system for PO's that need to be entered into a system. The problem is that a PO can be split into multiple truckloads and delivered to the facility on mutliple dates. The facility enters each PO that is needed based on a schedule but if the PO had been received previously, they do not want…
-
Checking multiple sheets for duplicates
Hi, I have a workspace that is being used for uploading new information by a group of techs. This information is checked and then uploaded a database by another team. Currently, I have the sheet working to check duplicates within one sheet, but once the data is uploaded to the database the line is moved to another…
-
Finding Duplicates
Tried using the "find duplicates formula" that are posted in the community, everyone seems to be working, for some strange reason mine is not, wonder why…
-
Identify Duplicate Submissions
Hello I'm trying to find a way to identify or highlight duplicate submissions for travel documents. We have various fields that are required for travel submissions, but the ones that area always consistent are the employee ID and departure dates. I've seen some formulas for IF/CountIFs but can't seem to get them to work…
-
Merged: 08075826: how to highlight duplicate values
This discussion has been merged.
-
My contacts do not display in Contact Picker
I imported 140 contacts successfully. They are listed in the "My Contacts" view. However, when I try to pick a user in a column, only my own user contact appears under the "My Smartsheet Contacts" filter. If I add another contact manually in that picker it does not appear in the "My Smartsheet Contacts" view. Its as if…
-
Issue with Duplicate Rows When Using Smartsheet API in Integration with NetSuite
Hello! I've encountered an issue while integrating NetSuite and Smartsheet via API. The script works inconsistently and occasionally creates duplicate rows in the Smartsheet table. Current Script Logic: A record is created in NetSuite, triggering the script. The script collects data about the parent row. A request is sent…
-
Changing display name causing dups?
We have a custom built Smartsheet solution. When it was built the person's full name was used in various places in the solution, used in formula's and automations. What we have discovered now that we are using the solution, is when a person goes in and updates their display name in their settings, from Robert to Bob or…
-
Trying to find duplicates in a column so I can alert the submitter and remove the row.
After much research, I am still stumped. I have set up a Smartsheet that will allow users, via a form, request a date and time slot for hoteling (work desk reservation). I have a link in the form to the dashboard so they can look at the calendar to see if there is availability. I am sure some will not look at the calendar…
-
Duplicate Checkbox Column
I've been perusing the forums for how to have a checkbox column check a duplicate of a row and I can't get any of them to work the way I want them to. Criteria for checkbox being checked: Row ID shows up more than once AND Created column is not the most recent Once I get this figured out, I will have an automation where…