Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

How do I remove erronous contacts from the All Contacts repository?

Jamie Bachman
Jamie Bachman ✭
edited 12/09/19 inArchived 2016 Posts

I am the Admin on our company account. I have updated the User Management and My Smartsheet Contacts with the most accurate employee list. When I am assigning out or updating tasks, there are still erroneous and duplicate contacts in the All Contacts list. How do i remove them to avoid confusion?

Thanks!

Tags:
· Share on Facebook Share on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    Hello Jamie—it's possible that the contact column itself hasn't yet been updated in the sheet, or users are still shared on the sheet. The dropdown that appears when typing in a contact populates from four sources:

    1. Your Smartsheet Contacts

    2. Other email addresses entered in the Contact type column on the sheet.

    3. Users shared to the sheet.

    4. Active users in Account > User Management

    I'd recommend unsharing users from the sheet, and manually removing their email addresses from any Contact type columns in your sheet.

    If the above doesn't work, please reach out to[email protected]for further assistance.

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

Hi @Coen<\/a> ,<\/p>

Give this a try.<\/p>

=IF(ISBLANK([Transaction Date]@row), \"//www.santa-greenland.com/community/discussion/\", IF([Transaction Date]@row < DATE(2023, 3, 31), \"Old - Cost Center\", \"New - Cost Center\"))<\/p>

Hope that helps,<\/p>

Dave<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":110452,"type":"question","name":"How to add date condition to IF\/AND equation","excerpt":"I have multiple IF\/AND equations in a column formula. I want to add a condition to the IF\/AND equations to apply before a certain date in a column(Date of Shoot). This is an example of one of the formulas: IF(AND(Talent@row = \"Agency\", Time@row = \"Half\", [Date of Shoot]@row < DATE(2023, 9, 16), 250 But is shows as…","snippet":"I have multiple IF\/AND equations in a column formula. I want to add a condition to the IF\/AND equations to apply before a certain date in a column(Date of Shoot). This is an…","categoryID":322,"dateInserted":"2023-09-19T18:43:18+00:00","dateUpdated":null,"dateLastComment":"2023-09-19T20:56:25+00:00","insertUserID":166827,"insertUser":{"userID":166827,"name":"mpajuelo","url":"https:\/\/community.smartsheet.com\/profile\/mpajuelo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T20:56:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":166827,"lastUser":{"userID":166827,"name":"mpajuelo","url":"https:\/\/community.smartsheet.com\/profile\/mpajuelo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T20:56:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3390307183,"url":"https:\/\/community.smartsheet.com\/discussion\/110452\/how-to-add-date-condition-to-if-and-equation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110452\/how-to-add-date-condition-to-if-and-equation","format":"Rich","lastPost":{"discussionID":110452,"commentID":396043,"name":"Re: How to add date condition to IF\/AND equation","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396043#Comment_396043","dateInserted":"2023-09-19T20:56:25+00:00","insertUserID":166827,"insertUser":{"userID":166827,"name":"mpajuelo","url":"https:\/\/community.smartsheet.com\/profile\/mpajuelo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T20:56:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-19T20:56:06+00:00","dateAnswered":"2023-09-19T20:06:30+00:00","acceptedAnswers":[{"commentID":396019,"body":"

Hi @mpajuelo<\/a> <\/p>

You are missing 2 closed parens. Try the below.<\/p>

=IF(AND(Talent@row = \"Agency\", Time@row = \"Half\", [Date of Shoot]@row < DATE(2023, 9, 16)), 250)<\/p>

Hope this helps,<\/p>

Dave<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":110422,"type":"question","name":"Calculating Dynamicly Average","excerpt":"Hi there , İ need a formula for a dynamic calculation , i added a sample as below , lets explain what i need ; At below table yellow field area contains August 2023 datas, white field area contains September 2023 datas , imagine that every each month , i amm adding new lines to this table also , So i have a dynamic tabe…","snippet":"Hi there , İ need a formula for a dynamic calculation , i added a sample as below , lets explain what i need ; At below table yellow field area contains August 2023 datas, white…","categoryID":322,"dateInserted":"2023-09-19T06:47:30+00:00","dateUpdated":"2023-09-19T06:48:00+00:00","dateLastComment":"2023-09-19T11:29:11+00:00","insertUserID":124542,"insertUser":{"userID":124542,"name":"Automatic Mail","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Automatic%20Mail","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9Y6QI9Q1XHYE\/nX1892FCZLO4A.JPG","dateLastActive":"2023-09-19T11:29:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":124542,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-20T09:11:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":31,"score":null,"hot":3390232001,"url":"https:\/\/community.smartsheet.com\/discussion\/110422\/calculating-dynamicly-average","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110422\/calculating-dynamicly-average","format":"Rich","tagIDs":[254,595],"lastPost":{"discussionID":110422,"commentID":395851,"name":"Re: Calculating Dynamicly Average","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/395851#Comment_395851","dateInserted":"2023-09-19T11:29:11+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-20T09:11:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2CPL8OIIQPCE\/sample-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"sample.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-19T11:24:28+00:00","dateAnswered":"2023-09-19T11:18:16+00:00","acceptedAnswers":[{"commentID":395849,"body":"

No problem, it's a fairly simple adjustment:<\/p>

=Price@row \/ SUMIF(Date:Date, AND(YEAR(@cell) = YEAR(Date@row), MONTH(@cell) = MONTH(Date@row)), Price:Price)<\/p>

Example with some data for August last year added on:<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":595,"urlcode":"help","name":"help"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Nested IF's with blank cells.

    Good afternoon Community! I'm working on a formula that will Assign a "New" or "Old" Cost center based on a date field. I have this functioning properly using the following formula: =IF([Transaction Date]@row < DATE(2023, 3, 31), "Old - Cost Center", "New - Cost Center") Now, I am trying to add in a feature that will leave…

  • How to add date condition to IF/AND equation

    I have multiple IF/AND equations in a column formula. I want to add a condition to the IF/AND equations to apply before a certain date in a column(Date of Shoot). This is an example of one of the formulas: IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16), 250 But is shows as…

  • Calculating Dynamicly Average

    Hi there , İ need a formula for a dynamic calculation , i added a sample as below , lets explain what i need ; At below table yellow field area contains August 2023 datas, white field area contains September 2023 datas , imagine that every each month , i amm adding new lines to this table also , So i have a dynamic tabe…