使用内容

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-12T18:08:14+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-12T18:12:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":147119,"lastUser":{"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-12T18:12:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3336291793,"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":350972,"name":"Re: Order Many Values in Control Center Modify Column Global Update UI?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350972#Comment_350972","dateInserted":"2022-11-12T18:08:14+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-12T18:12: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":"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":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-12T16:04:49+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":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-12T17:23:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3336462020,"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":350968,"name":"Re: Grouping issue in a report","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350968#Comment_350968","dateInserted":"2022-11-12T16:04:49+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-12T17:23:23+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-12T17:23:23+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":29526,"type":"discussion","name":"export filtered results","excerpt":"Hi, When applying a filter in smartsheet and then exporting the filtered results, it exports the whole sheet included filtered out rows. This is really annoying because in this way the filtering does not help you at all. Can this be fixed please? Thanks, Geert.","categoryID":321,"dateInserted":"2018-07-30T04:25:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-11-12T15:47:32+00:00","insertUserID":56076,"insertUser":{"userID":56076,"name":"gegoe76","url":"https:\/\/community.smartsheet.com\/profile\/gegoe76","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-30T04:23:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154657,"lastUser":{"userID":154657,"name":"Jatin Rathi","url":"https:\/\/community.smartsheet.com\/profile\/Jatin%20Rathi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-13T01:58:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":2212,"score":1,"hot":3201202063,"url":"https:\/\/community.smartsheet.com\/discussion\/29526\/export-filtered-results","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29526\/export-filtered-results","format":"Html","lastPost":{"discussionID":29526,"commentID":350961,"name":"Re: export filtered results","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350961#Comment_350961","dateInserted":"2022-11-12T15:47:32+00:00","insertUserID":154657,"insertUser":{"userID":154657,"name":"Jatin Rathi","url":"https:\/\/community.smartsheet.com\/profile\/Jatin%20Rathi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-13T01:58:48+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":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":97543,"type":"question","name":"The Smartsheet search function no longer provides Primary Column data in the results.","excerpt":"Smartsheets used to provide Primary Column data as part of the search results. It appears that with a recent update this longer works. Search results are nearly useless as one must now click through each result to find the entry of interest. According to this article,…","categoryID":321,"dateInserted":"2022-11-09T13:59:49+00:00","dateUpdated":null,"dateLastComment":"2022-11-12T11:24:24+00:00","insertUserID":154726,"insertUser":{"userID":154726,"name":"Bruce.Martin","url":"https:\/\/community.smartsheet.com\/profile\/Bruce.Martin","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1qilgbanPYtHaUFC7vOSfVBGvvjPU_dqCDyFLM=s96-c","dateLastActive":"2022-11-09T13:59:53+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\/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":21,"score":null,"hot":3336255253,"url":"https:\/\/community.smartsheet.com\/discussion\/97543\/the-smartsheet-search-function-no-longer-provides-primary-column-data-in-the-results","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97543\/the-smartsheet-search-function-no-longer-provides-primary-column-data-in-the-results","format":"Rich","tagIDs":[214],"lastPost":{"discussionID":97543,"commentID":350959,"name":"Re: The Smartsheet search function no longer provides Primary Column data in the results.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350959#Comment_350959","dateInserted":"2022-11-12T11:24:24+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-12T11:24:24+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-12 11:24:24","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":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":214,"urlcode":"Search","name":"Search"}]},{"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":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-12T23:35:20+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-12T23:35:20+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-12T23:35:20+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-12T18:59:46+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-12T17:23:23+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-12T17:23:23+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-12T18:59:46+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"}]}],"title":"Recent Discussions","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">