API & Developers

with contents from another external site? \/\/ Leif","categoryID":320,"dateInserted":"2018-11-02T12:51:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-11-02T18:43:52+00:00","insertUserID":49531,"insertUser":{"userID":49531,"name":"Pejl","url":"https:\/\/community.smartsheet.com\/profile\/Pejl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-05\/69\/a7\/n69a7bb865b53771f6da8d0041efc02e4.png","dateLastActive":"2018-11-02T12:47:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":49531,"lastUser":{"userID":49531,"name":"Pejl","url":"https:\/\/community.smartsheet.com\/profile\/Pejl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-05\/69\/a7\/n69a7bb865b53771f6da8d0041efc02e4.png","dateLastActive":"2018-11-02T12:47:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":139,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/35041\/dashboard-widget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/35041\/dashboard-widget","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"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":34941,"type":"discussion","name":"ODBC Connections and Outside Apps","excerpt":"Hi all, Hoping i can find some recommendations that can assist with an app development. I am creating a simple VS2010 Visual Basic app and report that will create purchase orders using smartsheet as the database back end. I have unlocked the smartsheet potential in ODBC connection but I am wondering if anyone has…","categoryID":320,"dateInserted":"2018-11-01T04:38:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-11-01T19:28:00+00:00","insertUserID":67726,"insertUser":{"userID":67726,"name":"Aviva","url":"https:\/\/community.smartsheet.com\/profile\/Aviva","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-11-01T04:32:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":67726,"lastUser":{"userID":67726,"name":"Aviva","url":"https:\/\/community.smartsheet.com\/profile\/Aviva","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-11-01T04:32:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":227,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/34941\/odbc-connections-and-outside-apps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34941\/odbc-connections-and-outside-apps","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"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":34061,"type":"discussion","name":"Alterar o modo de visualização da planilha individualmente","excerpt":"Olá, foi o possível substituto do modo de exibição da planilha doce? a Planilha é compartilhada, mas todo usuário tem sua função e visualiza o conteúdo de forma, porém, cada mudança, por exemplo, no tamanho da barra, altera para todos os usuários, sendo que essa alteração é tão séria necessário para um único usuário. ","categoryID":320,"dateInserted":"2018-10-18T09:50:19+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-11-01T13:12:28+00:00","insertUserID":65606,"insertUser":{"userID":65606,"name":"Cindygrrj","url":"https:\/\/community.smartsheet.com\/profile\/Cindygrrj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-18T09:46:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":42006,"lastUser":{"userID":42006,"name":"Corinne Flanagan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Corinne%20Flanagan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/38\/aa\/n38aac4ede0be15fd03c5f6597a047a32.jpg","dateLastActive":"2023-05-03T22:27:31+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":134,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/34061\/alterar-o-modo-de-visualizacao-da-planilha-individualmente","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34061\/alterar-o-modo-de-visualizacao-da-planilha-individualmente","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":26231,"type":"discussion","name":"Drag & Drop Card View on mobile IOS\/Android","excerpt":"Hello, I am able request the desktop site on any mobile device via the browser settings which allows to view cards. Touches work. Check boxes, Drop down menu etc. The only thing that does not work is the drag and drop function on mobile. Are there any plans to include this functionality with JQuery or some other?. Sencha…","categoryID":320,"dateInserted":"2018-05-31T15:39:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-31T15:58:21+00:00","insertUserID":44226,"insertUser":{"userID":44226,"name":"Eric420215","url":"https:\/\/community.smartsheet.com\/profile\/Eric420215","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-06T12:11:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":38096,"lastUser":{"userID":38096,"name":"ChrisB","url":"https:\/\/community.smartsheet.com\/profile\/ChrisB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-06\/dd\/90\/ndd90c29ffb5c9cad8dcc7be8aa144e59.jpg","dateLastActive":"2018-10-31T15:54:26+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":394,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/26231\/drag-drop-card-view-on-mobile-ios-android","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26231\/drag-drop-card-view-on-mobile-ios-android","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":246,"urlcode":"Mobile","name":"Mobile"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":444,"urlcode":"card-view","name":"Card View"},{"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}]},{"discussionID":32791,"type":"discussion","name":"Customer add\/edit sheet rows","excerpt":"I need customers to be able to add rows of information to a smart sheet, and later be able to edit those rows. A scrolling table view interface would work better than a form so users can see multiple records at a time. The sheet needs to be secure so that customers can only see\/edit their information, and not be able to…","categoryID":320,"dateInserted":"2018-09-29T09:58:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-26T07:12:52+00:00","insertUserID":62826,"insertUser":{"userID":62826,"name":"SnacKiwi","url":"https:\/\/community.smartsheet.com\/profile\/SnacKiwi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-29T09:46:32+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-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":196,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/32791\/customer-add-edit-sheet-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/32791\/customer-add-edit-sheet-rows","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":273,"urlcode":"Security","name":"Security"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":34566,"type":"discussion","name":"Google calendar tab hyperlink from home page","excerpt":"Mike here from Australia - can you tell me is there a way to hyperlink from the Smart Sheets home page I want to make a google calendar tab that hyperlinks directly to my google calendar and not via a cell in a sheet - see attached image and tab, I would like to be able to click the tab to open an external link - any way…","categoryID":320,"dateInserted":"2018-10-25T17:00:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-25T17:20:33+00:00","insertUserID":66716,"insertUser":{"userID":66716,"name":"Middyserp","url":"https:\/\/community.smartsheet.com\/profile\/Middyserp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-25T16:48:59+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-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":124,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/34566\/google-calendar-tab-hyperlink-from-home-page","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34566\/google-calendar-tab-hyperlink-from-home-page","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-10\/32\/e5\/32e5b564954c7fbbbfa900e1adf58976.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"google calendar tab.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"}],"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":34086,"type":"discussion","name":"Sporatic Error, using the API.","excerpt":"Hello Everyone. I have another weird error. the spread sheet I am making is 35 columns across and 270 rows down. I do batch updates exclusively. And I also time my updates to the most updates are 160 a minute to not overload the Server(a 200 ms delay between updates). sometimes mid way through the updates Im getting *…","categoryID":320,"dateInserted":"2018-10-18T11:36:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-24T14:49:09+00:00","insertUserID":65611,"insertUser":{"userID":65611,"name":"Steven M","url":"https:\/\/community.smartsheet.com\/profile\/Steven%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZRlZWTGIbzw!bZDa2634U2Y!5znlUbKVjC5","dateLastActive":"2022-01-26T14:34:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8971,"lastUser":{"userID":8971,"name":"IanN","title":"","url":"https:\/\/community.smartsheet.com\/profile\/IanN","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/7e\/ca\/n7eca990a69ff96e62b29bd69daedbc85.jpg","dateLastActive":"2023-06-02T15:54:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":561,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/34086\/sporatic-error-using-the-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34086\/sporatic-error-using-the-api","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"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":34066,"type":"discussion","name":"A Formatting Glitch, using the API.","excerpt":"Hello. I have developed a Script (Powershell), that will create a complete smartsheet. This smart sheet is created with colours based on various times on the source data, (Late, ontime, etc. ). My problem is when I update it again, the first column will keep the shading of the previous entries. even though I specify a…","categoryID":320,"dateInserted":"2018-10-18T09:59:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-24T14:27:54+00:00","insertUserID":65611,"insertUser":{"userID":65611,"name":"Steven M","url":"https:\/\/community.smartsheet.com\/profile\/Steven%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZRlZWTGIbzw!bZDa2634U2Y!5znlUbKVjC5","dateLastActive":"2022-01-26T14:34:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":65611,"lastUser":{"userID":65611,"name":"Steven M","url":"https:\/\/community.smartsheet.com\/profile\/Steven%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZRlZWTGIbzw!bZDa2634U2Y!5znlUbKVjC5","dateLastActive":"2022-01-26T14:34:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":134,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/34066\/a-formatting-glitch-using-the-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34066\/a-formatting-glitch-using-the-api","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-10\/fe\/d4\/fed4851d4531abae3da74c2ac9c89f5b.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SSCapture.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"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":34316,"type":"discussion","name":"Screen blurs for lengthy formulas, or multiple parentheses","excerpt":" Whenever, I try to use if statements or so, the screen blurs and is very irritating to the eye. Could this be fixed ? Example : =IF(AND([Total Man hours]7 >= 1, [Total Man hours]7 <= 16), 1, IF(AND([Total Man hours]7 >= 17, [Total Man hours]7 <= 39), 2, IF(AND([Total Man hours]7 >= 40, [Total Man hours]7 <= 120), 3,…","categoryID":320,"dateInserted":"2018-10-22T19:03:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-23T08:29:47+00:00","insertUserID":66206,"insertUser":{"userID":66206,"name":"Mohammed Sulaiman","url":"https:\/\/community.smartsheet.com\/profile\/Mohammed%20Sulaiman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-01T20:42:29+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-07-14T20:36:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":132,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/34316\/screen-blurs-for-lengthy-formulas-or-multiple-parentheses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34316\/screen-blurs-for-lengthy-formulas-or-multiple-parentheses","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"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":33896,"type":"discussion","name":"Unrecognized or Invalid Emails??","excerpt":"When sharing sheets between My account and Others(business partners\/clients), I often run into unrecognized email accounts warnings\/alerts... (and I have to drop what I'm doing and setup a contact in \"My Smartsheet Contacts\"). Wondering how common of a need this might be. I might invest a bit of time to come up with a…","categoryID":320,"dateInserted":"2018-10-16T09:44:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-22T22:50:37+00:00","insertUserID":65291,"insertUser":{"userID":65291,"name":"Sheetboy James","url":"https:\/\/community.smartsheet.com\/profile\/Sheetboy%20James","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-16T09:58:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":38316,"lastUser":{"userID":38316,"name":"Isaac Jose","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Isaac%20Jose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-06\/5d\/c5\/n5dc5978318e80d19a8d0e31e1c0fdf67.PNG","dateLastActive":"2023-04-26T18:09:02+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":613,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/33896\/unrecognized-or-invalid-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/33896\/unrecognized-or-invalid-emails","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":300,"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}">