Add Ons and Integrations

This works fine However when one of the Column is a ZERO, I get a #DIVDE BY ZERRO error displayed. To address this error, I used an IFERROR but it's giving me an \"UNPARSEABLE\" error. I want the cell to…","categoryID":343,"dateInserted":"2023-06-30T16:32:54+00:00","dateUpdated":"2023-06-30T16:35:50+00:00","dateLastComment":"2023-06-30T18:58:03+00:00","insertUserID":161931,"insertUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T20:31:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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":3,"countViews":206,"score":null,"hot":3376296057,"url":"https:\/\/community.smartsheet.com\/discussion\/107147\/using-iferror-formula-still-getting-unparseable-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107147\/using-iferror-formula-still-getting-unparseable-error","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T18:53:59+00:00","dateAnswered":"2023-06-30T18:25:40+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":107135,"type":"question","name":"Manufacturing Production Report","excerpt":"Hello, I work for a relatively small manufacturing company where our production managers meet every single morning, give their production numbers, headcount, etc to the manufacturing managers for them to enter the data manually in excel every morning. We created a form in Smartsheet for the production managers to enter…","categoryID":343,"dateInserted":"2023-06-30T13:32:56+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T18:21:03+00:00","insertUserID":163042,"insertUser":{"userID":163042,"name":"karawelcome","title":"Administrative Assistant","url":"https:\/\/community.smartsheet.com\/profile\/karawelcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T14:20:15+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":1,"countViews":140,"score":null,"hot":3376281839,"url":"https:\/\/community.smartsheet.com\/discussion\/107135\/manufacturing-production-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107135\/manufacturing-production-report","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-30T18:21:03+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":265,"urlcode":"reports","name":"Reports"}],"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":107142,"type":"question","name":"Dynamic View not allowing editable field","excerpt":"Hi, I have 2 fields in my Dynamic View that are built exactly the same way. One is showing as Read Only and the other Required. They both need to be Required. Anyone else having this issue? I just built this last week and was working correctly until today.","categoryID":343,"dateInserted":"2023-06-30T15:30:52+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T16:08:48+00:00","insertUserID":116932,"insertUser":{"userID":116932,"name":"Darla Brown","title":"Executive Assistant, Overachiever, Smartnerd","url":"https:\/\/community.smartsheet.com\/profile\/Darla%20Brown","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PUX9L5DJOKNW\/n0L3DIK3QSFXJ.jpg","dateLastActive":"2023-08-25T21:25:11+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":150,"score":null,"hot":3376282180,"url":"https:\/\/community.smartsheet.com\/discussion\/107142\/dynamic-view-not-allowing-editable-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107142\/dynamic-view-not-allowing-editable-field","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/5JPTRQJ4FVMN\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T16:04:54+00:00","dateAnswered":"2023-06-30T15:49:28+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":107109,"type":"question","name":"Bridge Workflow - Runs with no Errors but doesn't copy data to column. Am I missing modules?","excerpt":"I have a Bridge Workflow that is set up to copy data from a row\/column to the same row\/different column. The workflow runs with all module steps \"SUCCEDED\". However, the end result is not copied in my Smartsheet's target column. Its blank. Am I missing a module or module steps to complete the copy routine? -- Here's a…","categoryID":343,"dateInserted":"2023-06-29T21:27:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T15:01:40+00:00","insertUserID":148855,"insertUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2023-08-25T14:19:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":147,"score":null,"hot":3376213174,"url":"https:\/\/community.smartsheet.com\/discussion\/107109\/bridge-workflow-runs-with-no-errors-but-doesnt-copy-data-to-column-am-i-missing-modules","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107109\/bridge-workflow-runs-with-no-errors-but-doesnt-copy-data-to-column-am-i-missing-modules","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/G9744765U09U\/screenshot-28106-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot (106).png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T14:52:58+00:00","dateAnswered":"2023-06-30T11:53:00+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"}],"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":107080,"type":"question","name":"Need to update a field in Document Builder that uses Docusign","excerpt":"Hello, I inherited a sheet that uses document builder and docusign to generate a letter that has to be signed by multiple people. I understand that in the template editor the fields that in blue refer to columns in the generating sheet. However, I need to edit the options for a field that is not in blue, and I cannot…","categoryID":343,"dateInserted":"2023-06-29T13:21:00+00:00","dateUpdated":"2023-06-29T13:31:29+00:00","dateLastComment":"2023-06-30T11:16:01+00:00","insertUserID":113911,"insertUser":{"userID":113911,"name":"Andrew Nidiffer","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Nidiffer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T11:56:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":140,"score":null,"hot":3376169221,"url":"https:\/\/community.smartsheet.com\/discussion\/107080\/need-to-update-a-field-in-document-builder-that-uses-docusign","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107080\/need-to-update-a-field-in-document-builder-that-uses-docusign","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/U7PLE2F2DOX7\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-30T11:16:01+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":106966,"type":"question","name":"How to hide attachments and Comments in Reports within WorkApps","excerpt":"We have some internal sensitive data saved as attachments that we do not want our clients to see. I have hidden the Attachments and Comments Column on the Reports and saved them as View Only within WorkApps. However, the users can still view the attachment even though I have hidden the Attachment column, by right clicking…","categoryID":343,"dateInserted":"2023-06-27T18:09:54+00:00","dateUpdated":"2023-06-28T08:40:44+00:00","dateLastComment":"2023-06-29T22:46:36+00:00","insertUserID":105591,"insertUser":{"userID":105591,"name":"Warren Labuschagne","url":"https:\/\/community.smartsheet.com\/profile\/Warren%20Labuschagne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-26T18:17:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":156,"score":null,"hot":3375971190,"url":"https:\/\/community.smartsheet.com\/discussion\/106966\/how-to-hide-attachments-and-comments-in-reports-within-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106966\/how-to-hide-attachments-and-comments-in-reports-within-workapps","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-28T09:08:27+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":268,"urlcode":"attachments","name":"Attachments"},{"tagID":371,"urlcode":"workapps","name":"WorkApps"}],"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":107046,"type":"question","name":"How to add project dashboard link to project metadata sheet when using PMO template","excerpt":"Need some help here. Set up the PMO using the PMO template. PMs have added projects but the project dashboard hyperlink never populated in the intake sheet nor the project metadata. Trying to add that in now, as the project plan is already created. I've tried to hyperlink the project dashboard URL, copy\/past the URL in the…","categoryID":343,"dateInserted":"2023-06-28T18:45:39+00:00","dateUpdated":null,"dateLastComment":"2023-06-29T12:11:09+00:00","insertUserID":162917,"insertUser":{"userID":162917,"name":"swaters","url":"https:\/\/community.smartsheet.com\/profile\/swaters","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T18:54:58+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":3,"countViews":147,"score":null,"hot":3376020408,"url":"https:\/\/community.smartsheet.com\/discussion\/107046\/how-to-add-project-dashboard-link-to-project-metadata-sheet-when-using-pmo-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107046\/how-to-add-project-dashboard-link-to-project-metadata-sheet-when-using-pmo-template","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-29T10:26:58+00:00","dateAnswered":"2023-06-28T18:54:05+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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}">