How can I delete a Contact on a shared Sheet?
I am working in a shared Sheet that has duplicate entries for some Contacts and we'd like to remove them, but we can't figure out how to delete or edit them so that everyone can see the updated contacts.
Best Answer
-
Hi
You can use the following methods :- Find and Identify Duplicates
- Step 1.1: Use the "Find" feature in Smartsheet.
- Trigger: User presses Ctrl + F (Windows) or Cmd + F (Mac).
- Input: Contact name or identifier (e.g., email address).
- Output: Highlighted cells with potential duplicates.
- Step 1.2: Sort the sheet by contact name or unique identifier.
- Trigger: User clicks the column header to sort.
- Input: Column selection (e.g., contact name or email).
- Output: Grouped entries with possible duplicates.
- Step 1.1: Use the "Find" feature in Smartsheet.
- Remove or Edit Duplicate Entries
- Step 2.1: Verify user permissions.
- If user has Editor or Admin permissions, proceed.
- Else, terminate the process or request permission upgrade.
- Step 2.2: Edit duplicate entries.
- Trigger: User clicks the cell to modify.
- Action: Update contact details with correct information.
- Step 2.3: Delete duplicate entries.
- Trigger: User selects rows containing duplicates.
- Action: Right-click selected row → Delete Row.
- Step 2.1: Verify user permissions.
- Publish Changes
- Step 3.1: Verify sharing permissions for all users.
- Ensure that users have appropriate permissions (Viewer, Editor, Admin) to see updates.
- Step 3.2: Ensure real-time visibility.
- Trigger: User checks for updates.
- Action: Instruct users to refresh the sheet or log out and log back in if changes are not visible.
- Step 3.1: Verify sharing permissions for all users.
- Optional: Apply Conditional Formatting
- Step 4.1: Create a rule to highlight duplicates.
- Input: Column with potential duplicates (e.g., name or email).
- Action: Apply a condition (e.g., color highlighting) to rows where duplicates are found.
- Step 4.1: Create a rule to highlight duplicates.
- End Process
- Output: Duplicate contacts removed, and updates visible to all users.
- Find and Identify Duplicates
Answers
-
Hi
You can use the following methods :- Find and Identify Duplicates
- Step 1.1: Use the "Find" feature in Smartsheet.
- Trigger: User presses Ctrl + F (Windows) or Cmd + F (Mac).
- Input: Contact name or identifier (e.g., email address).
- Output: Highlighted cells with potential duplicates.
- Step 1.2: Sort the sheet by contact name or unique identifier.
- Trigger: User clicks the column header to sort.
- Input: Column selection (e.g., contact name or email).
- Output: Grouped entries with possible duplicates.
- Step 1.1: Use the "Find" feature in Smartsheet.
- Remove or Edit Duplicate Entries
- Step 2.1: Verify user permissions.
- If user has Editor or Admin permissions, proceed.
- Else, terminate the process or request permission upgrade.
- Step 2.2: Edit duplicate entries.
- Trigger: User clicks the cell to modify.
- Action: Update contact details with correct information.
- Step 2.3: Delete duplicate entries.
- Trigger: User selects rows containing duplicates.
- Action: Right-click selected row → Delete Row.
- Step 2.1: Verify user permissions.
- Publish Changes
- Step 3.1: Verify sharing permissions for all users.
- Ensure that users have appropriate permissions (Viewer, Editor, Admin) to see updates.
- Step 3.2: Ensure real-time visibility.
- Trigger: User checks for updates.
- Action: Instruct users to refresh the sheet or log out and log back in if changes are not visible.
- Step 3.1: Verify sharing permissions for all users.
- Optional: Apply Conditional Formatting
- Step 4.1: Create a rule to highlight duplicates.
- Input: Column with potential duplicates (e.g., name or email).
- Action: Apply a condition (e.g., color highlighting) to rows where duplicates are found.
- Step 4.1: Create a rule to highlight duplicates.
- End Process
- Output: Duplicate contacts removed, and updates visible to all users.
- Find and Identify Duplicates
-
Thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives