Global Updates -> Modify Column -> A dropdown list column ... Let's say you have a lot of values in this list column and you need to add ONE, but only one and it has to be #1 in the dropdowns rather than #12,…","categoryID":343,"dateInserted":"2022-11-09T17:14:59+00:00","dateUpdated":"2022-11-09T18:15:27+00:00","dateLastComment":"2022-11-12T10:34:58+00:00","insertUserID":147119,"insertUser":{"userID":147119,"name":"uwft","url":"https:\/\/community.smartsheet.com\/profile\/uwft","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu0k3xw9b-fhS_MBkpLiru0Mi2Yqs-Jn3Vhx0V3U=s96-c","dateLastActive":"2022-11-09T17:20:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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\/6CUXDYBP4XJP\/n7WFR145ZJ4ZX.png","dateLastActive":"2022-11-12T11:47:34+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":null,"hot":3336263997,"url":"https:\/\/community.smartsheet.com\/discussion\/97557\/order-many-values-in-control-center-modify-column-global-update-ui","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97557\/order-many-values-in-control-center-modify-column-global-update-ui","format":"Rich","tagIDs":[466],"lastPost":{"discussionID":97557,"commentID":350958,"name":"Re: Order Many Values in Control Center Modify Column Global Update UI?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350958#Comment_350958","dateInserted":"2022-11-12T10:34:58+00:00","insertUserID":120501,"insertUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/6CUXDYBP4XJP\/n7WFR145ZJ4ZX.png","dateLastActive":"2022-11-12T11:47:34+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/8TJ19IVBZBLV\/add-values-to-dropdown-in-control-center-modify-column.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"add values to dropdown in control center modify column.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-12T10:34:58+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-12 10:34:58","updateUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/6CUXDYBP4XJP\/n7WFR145ZJ4ZX.png","dateLastActive":"2022-11-12T11:47:34+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"}}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":466,"urlcode":"control-center","name":"Control Center"}]},{"discussionID":97673,"type":"question","name":"What is wrong with my record a date automation?","excerpt":"Here it is, Seemingly simple, but never runs, I cant understand why. FYI... INT is a checkbox column which is formula based, referencing another sheet. Essentially once two interviewers complete an interview form the box changes from 0 to 1. And then, I assumed that a date would be recorded in the Interview Date Column.…","categoryID":321,"dateInserted":"2022-11-12T09:24:59+00:00","dateUpdated":null,"dateLastComment":"2022-11-12T09:24:59+00:00","insertUserID":141676,"insertUser":{"userID":141676,"name":"BullandKhmer","url":"https:\/\/community.smartsheet.com\/profile\/BullandKhmer","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzZFJkJKb1xi3gnBxm9llncFkvlXVWZwHExs3_c=s96-c","dateLastActive":"2022-11-12T11:34:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":141676,"lastUser":{"userID":141676,"name":"BullandKhmer","url":"https:\/\/community.smartsheet.com\/profile\/BullandKhmer","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzZFJkJKb1xi3gnBxm9llncFkvlXVWZwHExs3_c=s96-c","dateLastActive":"2022-11-12T11:34:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":9,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/97673\/what-is-wrong-with-my-record-a-date-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97673\/what-is-wrong-with-my-record-a-date-automation","format":"Rich","lastPost":{"discussionID":97673,"name":"What is wrong with my record a date automation?","url":"https:\/\/community.smartsheet.com\/discussion\/97673\/what-is-wrong-with-my-record-a-date-automation","dateInserted":"2022-11-12T09:24:59+00:00","insertUserID":141676,"insertUser":{"userID":141676,"name":"BullandKhmer","url":"https:\/\/community.smartsheet.com\/profile\/BullandKhmer","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzZFJkJKb1xi3gnBxm9llncFkvlXVWZwHExs3_c=s96-c","dateLastActive":"2022-11-12T11:34:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/R6TIBKFH0FB2\/interview-complete.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Interview complete.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":21326,"type":"discussion","name":"Combine charts in Smartsheet","excerpt":"I would like add a chart to a dashboard showing actual vs forecast revenues per month. I need a combined chart - actual revenue shown in bar format and forecast shown in line format. I know you can do this type of chart in Excel however I'm struggling in Smartsheets I only have the option to have a line or bar chart. Is…","categoryID":321,"dateInserted":"2018-03-13T11:58:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-11-12T00:03:11+00:00","insertUserID":40616,"insertUser":{"userID":40616,"name":"Lindsay","url":"https:\/\/community.smartsheet.com\/profile\/Lindsay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-03-13T11:33:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154881,"lastUser":{"userID":154881,"name":"vnguyen08","url":"https:\/\/community.smartsheet.com\/profile\/vnguyen08","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-12T00:02:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":22,"countViews":2944,"score":4,"hot":3189168092,"url":"https:\/\/community.smartsheet.com\/discussion\/21326\/combine-charts-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/21326\/combine-charts-in-smartsheet","format":"Html","lastPost":{"discussionID":21326,"commentID":350952,"name":"Re: Combine charts in Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350952#Comment_350952","dateInserted":"2022-11-12T00:03:11+00:00","insertUserID":154881,"insertUser":{"userID":154881,"name":"vnguyen08","url":"https:\/\/community.smartsheet.com\/profile\/vnguyen08","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-12T00:02:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":4},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":97659,"type":"question","name":"Grouping issue in a report","excerpt":"Hi all, I have a report that includes tasks (primary) and assigned resource (person, using contact list) pulling from about 70 sheets - all with identical columns. When I group by the assigned resource, the report it's still splitting a several of the same resources into two different groups. I've double checked there…","categoryID":321,"dateInserted":"2022-11-11T18:25:31+00:00","dateUpdated":null,"dateLastComment":"2022-11-11T22:42:11+00:00","insertUserID":144226,"insertUser":{"userID":144226,"name":"Laura25","url":"https:\/\/community.smartsheet.com\/profile\/Laura25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T22:11:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144226,"lastUser":{"userID":144226,"name":"Laura25","url":"https:\/\/community.smartsheet.com\/profile\/Laura25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T22:11:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3336398862,"url":"https:\/\/community.smartsheet.com\/discussion\/97659\/grouping-issue-in-a-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97659\/grouping-issue-in-a-report","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":97659,"commentID":350948,"name":"Re: Grouping issue in a report","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350948#Comment_350948","dateInserted":"2022-11-11T22:42:11+00:00","insertUserID":144226,"insertUser":{"userID":144226,"name":"Laura25","url":"https:\/\/community.smartsheet.com\/profile\/Laura25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T22:11:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-11T20:05:05+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 20:05:05","updateUser":{"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":"2022-11-11T20:20:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":97440,"type":"question","name":"Start-to-Finish (SF) Not Working Correctly as of 11\/03\/22","excerpt":"I have had this problem since Friday, and it has wrecked my scheduling. There is an extra day being added to all durations when using the SF dependency. I have 1000's of cells now showing incorrect dates since this bug started at the end of last week. Finish-Finish (FF) also exhibits this problem, but Start-Start (SS) and…","categoryID":321,"dateInserted":"2022-11-07T15:47:21+00:00","dateUpdated":"2022-11-08T17:20:03+00:00","dateLastComment":"2022-11-11T21:53:14+00:00","insertUserID":154553,"insertUser":{"userID":154553,"name":"CrucialVelocity","url":"https:\/\/community.smartsheet.com\/profile\/CrucialVelocity","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T20:57:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":150781,"lastUser":{"userID":150781,"name":"Lorena","url":"https:\/\/community.smartsheet.com\/profile\/Lorena","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T22:40:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":102,"score":null,"hot":3336042635,"url":"https:\/\/community.smartsheet.com\/discussion\/97440\/start-to-finish-sf-not-working-correctly-as-of-11-03-22","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97440\/start-to-finish-sf-not-working-correctly-as-of-11-03-22","format":"Rich","lastPost":{"discussionID":97440,"commentID":350943,"name":"Re: Start-to-Finish (SF) Not Working Correctly as of 11\/03\/22","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350943#Comment_350943","dateInserted":"2022-11-11T21:53:14+00:00","insertUserID":150781,"insertUser":{"userID":150781,"name":"Lorena","url":"https:\/\/community.smartsheet.com\/profile\/Lorena","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T22:40:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NY3A50LGRNP2\/smartsheet-problem.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet problem.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-08T15:05:27+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-08 15:05:28","updateUser":{"userID":154670,"name":"Noelle","url":"https:\/\/community.smartsheet.com\/profile\/Noelle","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-10T00:16:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":76232,"type":"question","name":"Can you reload a form with fields prepopulated from the previous form submission?","excerpt":"We have a form that allows users to submit ideas for an upcoming conference. We want to allow them to submit as many different ideas as they'd like, each one on a separate row, so we have the form reloaded after each submission. We'd like to prepopulate a couple of fields on the reloaded form with data from the preceding…","categoryID":321,"dateInserted":"2021-02-16T16:35:22+00:00","dateUpdated":null,"dateLastComment":"2022-11-11T21:31:20+00:00","insertUserID":132069,"insertUser":{"userID":132069,"name":"Terry Dowdy","url":"https:\/\/community.smartsheet.com\/profile\/Terry%20Dowdy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-16T16:35:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":58851,"lastUser":{"userID":58851,"name":"Rofonic27","url":"https:\/\/community.smartsheet.com\/profile\/Rofonic27","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/89\/a2\/n89a22a74b1f4b617d2be4d45b7231270.jpg","dateLastActive":"2022-11-12T02:38:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":182,"score":null,"hot":3281698002,"url":"https:\/\/community.smartsheet.com\/discussion\/76232\/can-you-reload-a-form-with-fields-prepopulated-from-the-previous-form-submission","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76232\/can-you-reload-a-form-with-fields-prepopulated-from-the-previous-form-submission","format":"Rich","tagIDs":[204],"lastPost":{"discussionID":76232,"commentID":350937,"name":"Re: Can you reload a form with fields prepopulated from the previous form submission?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350937#Comment_350937","dateInserted":"2022-11-11T21:31:20+00:00","insertUserID":58851,"insertUser":{"userID":58851,"name":"Rofonic27","url":"https:\/\/community.smartsheet.com\/profile\/Rofonic27","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/89\/a2\/n89a22a74b1f4b617d2be4d45b7231270.jpg","dateLastActive":"2022-11-12T02:38:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-16T16:42:42+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":97647,"type":"question","name":"Why is % complete showing as 10,000% instead of 100?","excerpt":"I have a basic project sheet and the % complete is showing as 10,000% instead of 100% I have several other sheets where this is working correctly (ie I enter 100 and it stays as 100%, but in this one sheet when I put in 100, it defaults to 10,000%. I understand the basic math for how this equates but don't understand why…","categoryID":321,"dateInserted":"2022-11-11T14:02:12+00:00","dateUpdated":null,"dateLastComment":"2022-11-11T21:03:24+00:00","insertUserID":137499,"insertUser":{"userID":137499,"name":"Kelly Pratt","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Pratt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T21:00:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LBB70FV9GP52\/nY1AJCGUNDHDC.jpg","dateLastActive":"2022-11-12T03:33:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3336376536,"url":"https:\/\/community.smartsheet.com\/discussion\/97647\/why-is-complete-showing-as-10-000-instead-of-100","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97647\/why-is-complete-showing-as-10-000-instead-of-100","format":"Rich","lastPost":{"discussionID":97647,"commentID":350932,"name":"Re: Why is % complete showing as 10,000% instead of 100?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350932#Comment_350932","dateInserted":"2022-11-11T21:03:24+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LBB70FV9GP52\/nY1AJCGUNDHDC.jpg","dateLastActive":"2022-11-12T03:33:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-11T21:03:24+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 21:03:25","updateUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LBB70FV9GP52\/nY1AJCGUNDHDC.jpg","dateLastActive":"2022-11-12T03:33:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":97149,"type":"question","name":"Error Message \"Some cross-sheet formula can’t be updated\"","excerpt":"Dear Smart Team, I am getting below error message again which cause not triggering workflow automatically. \"Some cross-sheet formula can’t be updated, because this sheet has more cell referenced from other sheets than the maximum allowed (100000)\" How can I get the permanent solution to avoid this error. Refer attached…","categoryID":321,"dateInserted":"2022-10-30T17:04:44+00:00","dateUpdated":"2022-10-30T17:20:00+00:00","dateLastComment":"2022-11-11T20:01:50+00:00","insertUserID":136854,"insertUser":{"userID":136854,"name":"Ibrahim Khaleel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ibrahim%20Khaleel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2022-11-11T19:30:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":136854,"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":"2022-11-11T20:20:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":54,"score":null,"hot":3335349994,"url":"https:\/\/community.smartsheet.com\/discussion\/97149\/error-message-some-cross-sheet-formula-can-t-be-updated","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97149\/error-message-some-cross-sheet-formula-can-t-be-updated","format":"Rich","tagIDs":[254,472],"lastPost":{"discussionID":97149,"commentID":350905,"name":"Re: Error Message \"Some cross-sheet formula can’t be updated\"","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350905#Comment_350905","dateInserted":"2022-11-11T20:01:50+00:00","insertUserID":45516,"insertUser":{"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":"2022-11-11T20:20:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/COVDC46AQLAY\/reference-manager.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Reference Manager.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-11T19:23:27+00:00","dateAnswered":"2022-10-31T15:46:56+00:00","acceptedAnswers":[{"commentID":349300,"body":"
You are going to need to cut down on how many cells you are referencing. Maybe revisit some formulas to see if any can be made more efficient (INDEX\/MATCH instead of VLOOKUP), see if there is some way to consolidate data on the source sheet(s) before referencing it.<\/p>"},{"commentID":350900,"body":"
Dear Paul,<\/p>
Finally I replaced all vlookup formula with Index\/Match formula since i have mapped data with multiple sheets and now issue is permanently resolved.<\/p>
Thanks for your prompt support.<\/p>
Best regards,<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 19:23:04","updateUser":{"userID":136854,"name":"Ibrahim Khaleel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ibrahim%20Khaleel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2022-11-11T19:30:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}]},{"discussionID":97624,"type":"question","name":"Indexing Entries from a form generated worksheet","excerpt":"Good Afternoon Smartsheet Pros, I have created a form that allows the filer to input new hire information for up to 10 new employees in a batch (The need for multiple entry options on the same form was a requirement from the \"Powers that be\") I created helper spreadsheets indexing entries using the formula…","categoryID":321,"dateInserted":"2022-11-10T20:17:14+00:00","dateUpdated":null,"dateLastComment":"2022-11-11T20:00:04+00:00","insertUserID":154533,"insertUser":{"userID":154533,"name":"Daniel.Colwell","url":"https:\/\/community.smartsheet.com\/profile\/Daniel.Colwell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/FI7RXI4BXBK1\/nO83G9OO85O3D.jpg","dateLastActive":"2022-11-11T17:46:08+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":"2022-11-11T20:20:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3336310038,"url":"https:\/\/community.smartsheet.com\/discussion\/97624\/indexing-entries-from-a-form-generated-worksheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97624\/indexing-entries-from-a-form-generated-worksheet","format":"Rich","lastPost":{"discussionID":97624,"commentID":350903,"name":"Re: Indexing Entries from a form generated worksheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350903#Comment_350903","dateInserted":"2022-11-11T20:00:04+00:00","insertUserID":45516,"insertUser":{"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":"2022-11-11T20:20:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/T363BZCPHRQZ\/helper-sheet.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Helper-sheet.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-11T17:37:45+00:00","dateAnswered":"2022-11-11T17:12:23+00:00","acceptedAnswers":[{"commentID":350875,"body":"
If you click on a column header when creating the range, it will select the entire column and will include new entries as they are added to the sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 17:37:45","updateUser":{"userID":154533,"name":"Daniel.Colwell","url":"https:\/\/community.smartsheet.com\/profile\/Daniel.Colwell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/FI7RXI4BXBK1\/nO83G9OO85O3D.jpg","dateLastActive":"2022-11-11T17:46:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]}],"title":"Recent Discussions","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
