Sheets

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":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":44,"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":507,"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":7058,"type":"discussion","name":"Parent Relation on Progress %","excerpt":"Hi, i am trying to figure out how to create a parent relationship using the progress bar (0%, 25%, 50%, etc...) without having to enter 2 dates. I have a parent with 6 children rows under it. If i choose the progress bar as a colum property from symbols and select progree in the 6 children, I want the average to be…","categoryID":319,"dateInserted":"2017-01-25T10:30:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-25T13:58:30+00:00","insertUserID":10453,"insertUser":{"userID":10453,"name":"Laurenz Reichardt","url":"https:\/\/community.smartsheet.com\/profile\/Laurenz%20Reichardt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-25T10:27:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":279,"lastUser":{"userID":279,"name":"Kara Lumley","url":"https:\/\/community.smartsheet.com\/profile\/Kara%20Lumley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/95\/4e\/n954e10e9b436e9acd6f195bdf2312f07.jpg","dateLastActive":"2020-11-10T15:44:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":165,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/7058\/parent-relation-on-progress","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7058\/parent-relation-on-progress","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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":2167,"type":"discussion","name":"More column types?","excerpt":"Any chance we will see additional column formatting to include things like Currency and Phone number formatting? ","categoryID":317,"dateInserted":"2015-09-10T15:51:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-25T10:28:36+00:00","insertUserID":2848,"insertUser":{"userID":2848,"name":"Rex Germany","url":"https:\/\/community.smartsheet.com\/profile\/Rex%20Germany","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-11-23T09:08:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10396,"lastUser":{"userID":10396,"name":"John Daker","url":"https:\/\/community.smartsheet.com\/profile\/John%20Daker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-20T17:50:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":12,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/2167\/more-column-types","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/2167\/more-column-types","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":215,"urlcode":"templates","name":"Templates"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":281,"urlcode":"support","name":"Support"},{"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}">