Archived 2017 Posts

a sheet just to see what happens? When creating a master sheet, inset a hidden column \"Z_Row_Index. Enter \"1\" in the first cell and then \"2\" in the cell below. Highlight those two cells and drag the little widget at the bottom right of the lower cell. This will drag-fill the line…","categoryID":319,"dateInserted":"2017-01-20T11:04:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-26T14:15:05+00:00","insertUserID":3399,"insertUser":{"userID":3399,"name":"Jeremy Myers","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Myers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-23T12:16:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":53,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/7016\/index-rows-idiot-proof-your-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7016\/index-rows-idiot-proof-your-sheets","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/8d\/3b\/8d3b1c641f5f47347e8f3dc3734a191d.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Line Number.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"}],"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":7037,"type":"discussion","name":"Using a homeless \"By Name List\" and setting proper permissions","excerpt":"I work for United Way and we are currently incharge of managing our communities homeless \"By Name Lists\". In a nutshell, these are lists of current homeless people in our community, and is a way for agencies that provide housing to work together in helping people get housed. Also, because we're a non-profit, we only have…","categoryID":319,"dateInserted":"2017-01-23T11:08:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-26T14:08:56+00:00","insertUserID":10271,"insertUser":{"userID":10271,"name":"Jon Magee - Home for Good","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Magee%20-%20Home%20for%20Good","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-12T13:29:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":9,"countViews":22,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/7037\/using-a-homeless-by-name-list-and-setting-proper-permissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7037\/using-a-homeless-by-name-list-and-setting-proper-permissions","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User 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":6910,"type":"discussion","name":"Informal user survey: task completion check boxes","excerpt":"Hi, I keep running into systems that have a variety of names for check box columns that are intended to mark task completion. If you wouldn't mind, please follow this link: https:\/\/app.smartsheet.com\/b\/form?EQBCT=5b8cc9b3e70c42b2b20c795cf2a37877 to tell me the column name you use (or if you don't use one). I appreciate…","categoryID":319,"dateInserted":"2017-01-09T12:31:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-26T13:53:52+00:00","insertUserID":4374,"insertUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":32,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6910\/informal-user-survey-task-completion-check-boxes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6910\/informal-user-survey-task-completion-check-boxes","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/07\/ca\/07ca46645517d0aa255c9dd6b0298eba.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Survey_Completed_Checkbox.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","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":7077,"type":"discussion","name":"Enhancement Requests: Community \/ Help search","excerpt":"The number of threads on the Community has grown since i became active. In March 2016, there were about 2300 threads. There's more than double that now (466 pages x 10 per page) I'd like to see some improvements so I can find things more quickly. The search I am talking about is either here: Thanks Craig ","categoryID":319,"dateInserted":"2017-01-26T13:42:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-26T13:46:00+00:00","insertUserID":4374,"insertUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/7077\/enhancement-requests-community-help-search","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7077\/enhancement-requests-community-help-search","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2e\/81\/2e81af73df5fc7f518f9f95e44a80785.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Search1.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":214,"urlcode":"Search","name":"Search"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"}],"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":7059,"type":"discussion","name":"Drop down selection box legend","excerpt":"It would be really nice if when you set up a multiple choice slection box and you are using acronyms, that you could put a short description by each. I'm always trying to make columns narrower to allow more columns on the screen without having to use a slide bar to see more. I set up one column that indicates which…","categoryID":319,"dateInserted":"2017-01-25T11:03:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-26T11:46:16+00:00","insertUserID":8784,"insertUser":{"userID":8784,"name":"Daryl McCann","url":"https:\/\/community.smartsheet.com\/profile\/Daryl%20McCann","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-11-30T13:05:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":42,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/7059\/drop-down-selection-box-legend","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7059\/drop-down-selection-box-legend","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}],"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":7072,"type":"discussion","name":"CAB Change Advisory Board","excerpt":"Anyone has an idea of CAB template\/format. The company's requirenemnts is to track and report on tickets in their current review, approved\/rejected\/deferred. Status of in progress or completed. CAB takes place twise a week so the date of CAB is imprtant for historical purposes as well. It is not difficlut to create in…","categoryID":319,"dateInserted":"2017-01-25T21:53:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-26T09:38:23+00:00","insertUserID":9596,"insertUser":{"userID":9596,"name":"MB512","url":"https:\/\/community.smartsheet.com\/profile\/MB512","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-21T18:40:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":380,"lastUser":{"userID":380,"name":"rmw2121","url":"https:\/\/community.smartsheet.com\/profile\/rmw2121","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-26T09:28:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":123,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/7072\/cab-change-advisory-board","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7072\/cab-change-advisory-board","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"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":7073,"type":"discussion","name":"Combining calendars with work plans","excerpt":"Hello, My organization has the team plan (not Business). Is it possible to create a graphical calendar view that reports\/displays results with a traditional project\/work plan by department or function with tasks\/activities? If so, can you only create this on the same page within Smartsheets using Sights? I suppose it would…","categoryID":319,"dateInserted":"2017-01-25T22:39:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-26T05:42:31+00:00","insertUserID":2225,"insertUser":{"userID":2225,"name":"NPOHC","url":"https:\/\/community.smartsheet.com\/profile\/NPOHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-25T22:04:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7123,"lastUser":{"userID":7123,"name":"Tony Coleman","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Coleman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-24T04:53:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/7073\/combining-calendars-with-work-plans","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7073\/combining-calendars-with-work-plans","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","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":7070,"type":"discussion","name":"auto populate due dates","excerpt":"I want task due dates to auto populate based on one date that I enter as the event date. For example, I will set an event date and certain tasks will be due 2 weeks prior to event date. When I create individual event sheets, I want to enter that event date and then due dates will auto populate for each event based on that…","categoryID":319,"dateInserted":"2017-01-25T17:53:43+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-25T19:28:03+00:00","insertUserID":10470,"insertUser":{"userID":10470,"name":"Dion Chapman","url":"https:\/\/community.smartsheet.com\/profile\/Dion%20Chapman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-25T17:51:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":236,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/7070\/auto-populate-due-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7070\/auto-populate-due-dates","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","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}">