IT & Operations

From Web). We have switched our publish link to only be accessible to people on our account (instead of being published publicly), and the workflow now fails. I believe this is…","categoryID":321,"dateInserted":"2023-02-16T19:34:42+00:00","dateUpdated":null,"dateLastComment":"2023-02-21T14:28:35+00:00","insertUserID":139008,"insertUser":{"userID":139008,"name":"H.Colo","url":"https:\/\/community.smartsheet.com\/profile\/H.Colo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-30T21:12:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":139008,"lastUser":{"userID":139008,"name":"H.Colo","url":"https:\/\/community.smartsheet.com\/profile\/H.Colo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-30T21:12:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":58,"score":null,"hot":3353568197,"url":"https:\/\/community.smartsheet.com\/discussion\/101298\/from-web-excel-query-and-smartsheet-publish-link","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101298\/from-web-excel-query-and-smartsheet-publish-link","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-21T14:28:38+00:00","dateAnswered":"2023-02-20T17:46:28+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":223,"urlcode":"Publish","name":"Publish"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":59601,"type":"discussion","name":"CountIFs and Date range formula","excerpt":"Hi, need help with a formula. I am trying to count a type from one column 'Finding Rating' against a date range in another column 'Last Completed'. So far I have tried the following but they have all come up with UNPARSEABLE. FYI Conformance is one of the types that I need to count =COUNTIFS({Finding Rating}, =Conformance,…","categoryID":322,"dateInserted":"2019-10-07T20:21:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-02-17T09:20:11+00:00","insertUserID":92101,"insertUser":{"userID":92101,"name":"VioletB","url":"https:\/\/community.smartsheet.com\/profile\/VioletB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-08T23:20:09+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-06-02T16:20:39+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":2173,"score":null,"hot":3247114306,"url":"https:\/\/community.smartsheet.com\/discussion\/59601\/countifs-and-date-range-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59601\/countifs-and-date-range-formula","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":69636,"type":"question","name":"How can I add dividers in my dashboard?","excerpt":"Hello, I was hoping there would be a way to add dividers in my dashboard. Sharing the dashboard with our ELT, it could be easier to separate categories with line dividers that take up 1 square. Thank you, Paige","categoryID":321,"dateInserted":"2020-07-06T23:24:29+00:00","dateUpdated":null,"dateLastComment":"2023-02-14T18:59:36+00:00","insertUserID":123807,"insertUser":{"userID":123807,"name":"Paige Borchardt","url":"https:\/\/community.smartsheet.com\/profile\/Paige%20Borchardt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-09-09T15:00:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148949,"lastUser":{"userID":148949,"name":"PDunn","url":"https:\/\/community.smartsheet.com\/profile\/PDunn","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A5kqXy4qgzs!w4Er_yYbg3s!6Ajl8Hf7O7p","dateLastActive":"2023-06-02T20:13:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":3180,"score":3,"hot":3270484145,"url":"https:\/\/community.smartsheet.com\/discussion\/69636\/how-can-i-add-dividers-in-my-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69636\/how-can-i-add-dividers-in-my-dashboard","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-07-08T10:23:00+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":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":100825,"type":"discussion","name":"Certified Smartsheet user on the look out","excerpt":"Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…","categoryID":345,"dateInserted":"2023-02-07T23:03:29+00:00","dateUpdated":"2023-02-08T12:43:40+00:00","dateLastComment":"2023-02-07T23:03:29+00:00","insertUserID":66886,"insertUser":{"userID":66886,"name":"Stacey Carrasco","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Stacey%20Carrasco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/CDQUTBNMGA0A\/nBN27R38AVQBX.JPG","dateLastActive":"2023-06-02T17:03:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":66886,"lastUser":{"userID":66886,"name":"Stacey Carrasco","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Stacey%20Carrasco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/CDQUTBNMGA0A\/nBN27R38AVQBX.JPG","dateLastActive":"2023-06-02T17:03:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":0,"countViews":112,"score":1,"hot":3351671529,"url":"https:\/\/community.smartsheet.com\/discussion\/100825\/certified-smartsheet-user-on-the-look-out","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100825\/certified-smartsheet-user-on-the-look-out","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":345,"name":"Just for fun","url":"https:\/\/community.smartsheet.com\/categories\/just-for-fun","allowedDiscussionTypes":[]},"tags":[{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":29136,"type":"discussion","name":"Excel @Text() Functionality in Smartsheet?","excerpt":"Is there a way in Smartsheet to use a formula that gives the same result as using @text() in Excel? I have a spreadsheet that I need to concatenate several fields together and have the field then display as text. Most of what I see now for formulas is to covert from text into formula. But I need to go the other way? Use…","categoryID":322,"dateInserted":"2018-07-24T15:20:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-02-07T01:16:24+00:00","insertUserID":55471,"insertUser":{"userID":55471,"name":"Hospital_IT_PM","url":"https:\/\/community.smartsheet.com\/profile\/Hospital_IT_PM","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/bd\/21\/nbd211a677f523369189392c852e87637.jpg","dateLastActive":"2018-09-17T15:37:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137089,"lastUser":{"userID":137089,"name":"Adrian @ Chess","title":"Managing Director","url":"https:\/\/community.smartsheet.com\/profile\/Adrian%20%40%20Chess","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/Q3AKFSIMT4LI\/n46GTRXZF0SQ2.png","dateLastActive":"2023-05-24T04:04:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":933,"score":null,"hot":3208179406,"url":"https:\/\/community.smartsheet.com\/discussion\/29136\/excel-text-functionality-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29136\/excel-text-functionality-in-smartsheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":65374,"type":"question","name":"IF NOT ISBLANK help","excerpt":"I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patient is filled in but Order Request Date is blank, Green if Complete date is filled in,…","categoryID":322,"dateInserted":"2020-01-21T15:00:27+00:00","dateUpdated":null,"dateLastComment":"2023-02-01T13:03:41+00:00","insertUserID":114192,"insertUser":{"userID":114192,"name":"Zachary Mitchell","url":"https:\/\/community.smartsheet.com\/profile\/Zachary%20Mitchell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-02T14:58:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"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-06-04T20:59:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":377,"score":null,"hot":3254880848,"url":"https:\/\/community.smartsheet.com\/discussion\/65374\/if-not-isblank-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65374\/if-not-isblank-help","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/495\/LPC145RY25AL.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Snip 1.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-01-21T18:13:45+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":50136,"type":"discussion","name":"Column descriptions for Reports","excerpt":"Does anyone know if this has been submitted for enhancements, or if this option is coming in the near future?","categoryID":321,"dateInserted":"2019-06-10T11:56:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-01-31T18:16:39+00:00","insertUserID":91426,"insertUser":{"userID":91426,"name":"melinda.garza91426","url":"https:\/\/community.smartsheet.com\/profile\/melinda.garza91426","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-10T11:54:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":152636,"lastUser":{"userID":152636,"name":"JCardinal","title":"Project Manager\/Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/JCardinal","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7anvO45nVDI!3Jksv3JQizo!Oi3cvZb3qgt","dateLastActive":"2023-05-17T13:28:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":561,"score":2,"hot":3235358572,"url":"https:\/\/community.smartsheet.com\/discussion\/50136\/column-descriptions-for-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/50136\/column-descriptions-for-reports","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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}">