Contacts

Contact List or cell is RED","categoryID":322,"dateInserted":"2023-08-21T20:32:43+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T12:27:19+00:00","insertUserID":125555,"insertUser":{"userID":125555,"name":"Gina Prego","url":"https:\/\/community.smartsheet.com\/profile\/Gina%20Prego","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-23T23:49:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":37,"score":null,"hot":3385360202,"url":"https:\/\/community.smartsheet.com\/discussion\/109234\/formula-when-a-column-has-a-checkbox","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109234\/formula-when-a-column-has-a-checkbox","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-22T12:07:20+00:00","dateAnswered":"2023-08-21T22:18:02+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":245,"urlcode":"sharing","name":"Sharing and Collaboration"},{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":109128,"type":"idea","name":"Improve how logic functions work with contact columns","excerpt":"If a contact (e.g. one in my personal contact lists) has a text field name associated with it, it displays as that name. Then, if wanting to search for that contact in a contact column using the associated email address, it is not found. Please develop a function that returns as text the email address of a contact.…","categoryID":349,"dateInserted":"2023-08-17T23:07:42+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T23:07:42+00:00","insertUserID":126152,"insertUser":{"userID":126152,"name":"Bruce Northcote","url":"https:\/\/community.smartsheet.com\/profile\/Bruce%20Northcote","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DFlAQ-Faw7o!wV9CMKVHEPQ!0yqQeDcVhuK","dateLastActive":"2023-08-24T22:26:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":126152,"lastUser":{"userID":126152,"name":"Bruce Northcote","url":"https:\/\/community.smartsheet.com\/profile\/Bruce%20Northcote","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DFlAQ-Faw7o!wV9CMKVHEPQ!0yqQeDcVhuK","dateLastActive":"2023-08-24T22:26:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":31,"score":1,"hot":1692313962,"url":"https:\/\/community.smartsheet.com\/discussion\/109128\/improve-how-logic-functions-work-with-contact-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109128\/improve-how-logic-functions-work-with-contact-columns","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":537,"urlcode":"logic","name":"logic"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":109061,"type":"idea","name":"Add Email Distribution Lists Functionality to Contact Columns & Workflows","excerpt":"Our team and company use email distribution lists frequently, so it would be incredibly useful to be able to assign an email distribution list to a contact column and workflows so all members on that list would be notified accordingly.","categoryID":349,"dateInserted":"2023-08-16T21:01:17+00:00","dateUpdated":"2023-08-17T12:35:13+00:00","dateLastComment":"2023-08-16T21:01:17+00:00","insertUserID":165143,"insertUser":{"userID":165143,"name":"Jessica Limke","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Limke","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8xP2QVZaB2Av0MW4IX9nePuVy2vOVta2rdh_umuOKqMA=s96-c","dateLastActive":"2023-08-22T18:10:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":165143,"lastUser":{"userID":165143,"name":"Jessica Limke","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Limke","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8xP2QVZaB2Av0MW4IX9nePuVy2vOVta2rdh_umuOKqMA=s96-c","dateLastActive":"2023-08-22T18:10:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":40,"score":2,"hot":1692220277,"url":"https:\/\/community.smartsheet.com\/discussion\/109061\/add-email-distribution-lists-functionality-to-contact-columns-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109061\/add-email-distribution-lists-functionality-to-contact-columns-workflows","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":108932,"type":"question","name":"Split Contacts Past 20 Into a Separate Column","excerpt":"Hi, I have a form that is filled out to send a notification to a group of staff. The person creating the message fills out the form and pastes the list of email addresses (separated by semicolons) from another source to populate a Contact List column and automation sends a notification and reminders to the staff on that…","categoryID":322,"dateInserted":"2023-08-14T18:17:47+00:00","dateUpdated":"2023-08-14T18:42:40+00:00","dateLastComment":"2023-08-14T19:31:56+00:00","insertUserID":164142,"insertUser":{"userID":164142,"name":"bdow","title":"Data Operations Analyst","url":"https:\/\/community.smartsheet.com\/profile\/bdow","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9MRDMFF7NSYA\/n057LZKH96X2V.png","dateLastActive":"2023-08-23T12:43:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":164142,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":52,"score":null,"hot":3384079183,"url":"https:\/\/community.smartsheet.com\/discussion\/108932\/split-contacts-past-20-into-a-separate-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108932\/split-contacts-past-20-into-a-separate-column","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-08-14T19:31:56+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":247,"urlcode":"contacts","name":"Contacts"}],"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}]},{"discussionID":71999,"type":"question","name":"Dashboard - Embedding links to email addresses","excerpt":"I've seen some past posts on this topic but have not gotten the workaround to work and was hoping that there may be progress on a solution. At the 2020 Engage event, I saw a beautiful dashboard that had images and email links under a title: contacts. I'm trying to create the same on my dashboard. Any help or update? This…","categoryID":321,"dateInserted":"2020-10-07T19:26:56+00:00","dateUpdated":null,"dateLastComment":"2023-08-11T14:23:50+00:00","insertUserID":124874,"insertUser":{"userID":124874,"name":"Marie Toft","url":"https:\/\/community.smartsheet.com\/profile\/Marie%20Toft","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w-vV_z9NgL4!prjVqW91vCY!W69qx5tLe5u","dateLastActive":"2023-02-23T19:59:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":151431,"lastUser":{"userID":151431,"name":"Geilisa","url":"https:\/\/community.smartsheet.com\/profile\/Geilisa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZnspmT_we0s!7Ijp-7vLSzs!HbngNM8iINM","dateLastActive":"2023-08-14T18:09:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":2115,"score":1,"hot":3293868346,"url":"https:\/\/community.smartsheet.com\/discussion\/71999\/dashboard-embedding-links-to-email-addresses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71999\/dashboard-embedding-links-to-email-addresses","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/37ST6UXNJB6Q\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-08T23:51:08+00:00","dateAnswered":"2020-10-08T21:39:53+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">