IT & Operations

Q1 Total Demand Red: Q1Total Capacity < Q1 Total Demand Kind Regards, Luke","categoryID":322,"dateInserted":"2022-07-25T11:58:48+00:00","dateUpdated":null,"dateLastComment":"2022-07-27T20:21:28+00:00","insertUserID":145167,"insertUser":{"userID":145167,"name":"lukasrobbo97","url":"https:\/\/community.smartsheet.com\/profile\/lukasrobbo97","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u5C1Fy0Zo-Q!m2GynwcNWng!Uqo5bLXo02I","dateLastActive":"2022-08-18T12:04:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":133754,"lastUser":{"userID":133754,"name":"Scott Peters","url":"https:\/\/community.smartsheet.com\/profile\/Scott%20Peters","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QK9YYA22R88Y\/nEZ19DQAQ4262.png","dateLastActive":"2023-07-07T20:22:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":204,"score":null,"hot":3317704216,"url":"https:\/\/community.smartsheet.com\/discussion\/93550\/capacity-vs-demand-utilisation-rag-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93550\/capacity-vs-demand-utilisation-rag-column","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/M5POC3UVS1OD\/capture-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-27T20:21:28+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"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":93621,"type":"question","name":"How to identify the first date and last date from another smartsheet column?","excerpt":"I need to identify the following: Smartsheet 1, Column Start Date, row 1 cell 1 and Column End Date, row 1 cell 2 (need to obtain from smartsheet 2) Smartsheet 2, Column Start Date and Column End Date have several dates. Smartsheet 1 needs to identify the earliest Start Date and the latest End Date from these two columns…","categoryID":322,"dateInserted":"2022-07-26T23:23:31+00:00","dateUpdated":null,"dateLastComment":"2022-07-27T19:54:39+00:00","insertUserID":150693,"insertUser":{"userID":150693,"name":"Rob_NYC","url":"https:\/\/community.smartsheet.com\/profile\/Rob_NYC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/XU7FURNVBW44\/nNDNRDR4JD9VL.png","dateLastActive":"2022-09-17T16:10:03+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-07T18:30:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":215,"score":null,"hot":3317831290,"url":"https:\/\/community.smartsheet.com\/discussion\/93621\/how-to-identify-the-first-date-and-last-date-from-another-smartsheet-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93621\/how-to-identify-the-first-date-and-last-date-from-another-smartsheet-column","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-29T18:55:35+00:00","dateAnswered":"2022-07-27T19:54:39+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":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"},{"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":42266,"type":"discussion","name":"CTRL + ] Does Not Indent, But Right Clicking Does","excerpt":"Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child\/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. The keys are working just fine (able to CTRL + C\/V, and the [ and ] keys all work individually) but it does not allow…","categoryID":321,"dateInserted":"2019-02-25T13:46:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-07-26T09:17:18+00:00","insertUserID":72331,"insertUser":{"userID":72331,"name":"ajcooper35","url":"https:\/\/community.smartsheet.com\/profile\/ajcooper35","photoUrl":"https:\/\/lh3.googleusercontent.com\/-5L8GGKq82yw\/AAAAAAAAAAI\/AAAAAAAAAAA\/ACHi3rdhooWVupMc14pcvWaKY_6ug-g0iA\/photo.jpg","dateLastActive":"2020-01-20T14:35:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146177,"lastUser":{"userID":146177,"name":"Petra","url":"https:\/\/community.smartsheet.com\/profile\/Petra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T15:57:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":635,"score":null,"hot":3209936642,"url":"https:\/\/community.smartsheet.com\/discussion\/42266\/ctrl-does-not-indent-but-right-clicking-does","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/42266\/ctrl-does-not-indent-but-right-clicking-does","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"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":93140,"type":"question","name":"Getting last login information via API call","excerpt":"I have looked at the documentation for the API call but when I am hitting the users endpoint: https:\/\/api.smartsheet.com\/2.0\/users?include=lastLogin,source&includeAll=true it is not including the lastLogin information. If I hit: https:\/\/api.smartsheet.com\/2.0\/users?include=lastLogin then I will receive it for those users…","categoryID":320,"dateInserted":"2022-07-12T18:26:45+00:00","dateUpdated":null,"dateLastComment":"2022-07-23T08:05:51+00:00","insertUserID":149996,"insertUser":{"userID":149996,"name":"chuckleswk","url":"https:\/\/community.smartsheet.com\/profile\/chuckleswk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-04T20:21:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":120501,"lastUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DVF5D4UGT64P\/nS8NWAZKSMCNG.png","dateLastActive":"2023-06-29T14:57:59+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":175,"score":null,"hot":3316215756,"url":"https:\/\/community.smartsheet.com\/discussion\/93140\/getting-last-login-information-via-api-call","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93140\/getting-last-login-information-via-api-call","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-20T15:20:43+00:00","acceptedAnswers":[]}},"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":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":20611,"type":"discussion","name":"Conditional Formatting not applying consistently","excerpt":"I have a sheet with conditional formatting rules so that if there is a \"0\" in a cell the text will be gray and if there is a negative number it will be red. If I close the sheet and then open it again the conditional formatting does not show, but if I go into the setting and basically pretend to change the formatting it…","categoryID":321,"dateInserted":"2018-03-02T16:38:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-07-15T20:34:46+00:00","insertUserID":8217,"insertUser":{"userID":8217,"name":"Sara Morris","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20Morris","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-11T16:38:11+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-07-08T12:30:08+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":121,"score":null,"hot":3177929566,"url":"https:\/\/community.smartsheet.com\/discussion\/20611\/conditional-formatting-not-applying-consistently","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20611\/conditional-formatting-not-applying-consistently","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":218,"urlcode":"Construction","name":"Construction"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">