表

0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!","categoryID":322,"dateInserted":"2023-03-09T14:00:08+00:00","dateUpdated":null,"dateLastComment":"2023-03-09T19:44:14+00:00","insertUserID":159203,"insertUser":{"userID":159203,"name":"Ddyer","url":"https:\/\/community.smartsheet.com\/profile\/Ddyer","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxa99iDchMxhzP7JtJAXp0TdSi_szbSnpCWuh3qB=s96-c","dateLastActive":"2023-03-09T19:42:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159203,"lastUser":{"userID":159203,"name":"Ddyer","url":"https:\/\/community.smartsheet.com\/profile\/Ddyer","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxa99iDchMxhzP7JtJAXp0TdSi_szbSnpCWuh3qB=s96-c","dateLastActive":"2023-03-09T19:42:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":112,"score":null,"hot":3356762662,"url":"https:\/\/community.smartsheet.com\/discussion\/102359\/i-want-to-count-the-number-of-times-a-contact-appears-in-a-column-how-do-i-do-that","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102359\/i-want-to-count-the-number-of-times-a-contact-appears-in-a-column-how-do-i-do-that","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-09T19:42:47+00:00","dateAnswered":"2023-03-09T14:13:54+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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":91674,"type":"question","name":"Form Entries are Negative","excerpt":"Weekly I have about 15 sites completing the form linked below. The issue, I have roughly two random users each week entering a negative one into the form. One user who is pretty savvy indicated the form is defaulting to a negative one. https:\/\/app.smartsheet.com\/b\/form\/ebc99e53148a4a479060b3d695321030 I have NOT setup any…","categoryID":321,"dateInserted":"2022-06-01T06:07:08+00:00","dateUpdated":"2022-06-01T06:16:15+00:00","dateLastComment":"2023-03-09T19:32:23+00:00","insertUserID":119518,"insertUser":{"userID":119518,"name":"Amy Arnold","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Arnold","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!GpdD39UP27w!B_9DgcE2Wfo!f-wVNvq4uBf","dateLastActive":"2023-01-29T09:06:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":119518,"lastUserID":150107,"lastUser":{"userID":150107,"name":"Chris K","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20K","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zYvqc6ot0_M!nOEr3_YRCfs!3WulPBZJhWw","dateLastActive":"2023-04-10T16:28:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":347,"score":null,"hot":3332456371,"url":"https:\/\/community.smartsheet.com\/discussion\/91674\/form-entries-are-negative","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91674\/form-entries-are-negative","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/KF7GABIS117O\/smartsheet-2-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet 2.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-02T22:16:58+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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}">