登录提交新的想法和投票
开始

可编辑的列公式

我希望能够能够有一个公式自动填充在每一行在一列,但仍然能够编辑单元格手动,如果我需要不禁用列公式为每隔一行

标签:
2
2票

想法提交·最后一次更新

    2023-05-24T15:59:16.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106828,"type":"idea","name":"Increase cell character count","excerpt":"I use Smartsheet to document contract compliance. Sometimes compliance actions can take up to 2 years and I exceed the 4,000 characters in an excel cell. Is there a way to increase the # of characters in a cell?","categoryID":349,"dateInserted":"2023-06-23T14:26:58+00:00","dateUpdated":"2023-06-23T14:29:01+00:00","dateLastComment":"2023-06-23T14:39:15+00:00","insertUserID":162424,"insertUser":{"userID":162424,"name":"Kirsten George","title":"Compliance Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Kirsten%20George","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BJtogbPi6ns!nR9q38OJjvM!iSUyXXTv3O_","dateLastActive":"2023-06-23T14:40:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":2,"hot":3375062773,"url":"https:\/\/community.smartsheet.com\/discussion\/106828\/increase-cell-character-count","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106828\/increase-cell-character-count","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106828,"commentID":381984,"name":"Re: Increase cell character count","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381984#Comment_381984","dateInserted":"2023-06-23T14:39:15+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":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106820,"type":"idea","name":"Stacked column for two dimensional view, combining 2 groups in one column","excerpt":"We would like to be able to see in one stacked column\/bar the combination of two data groupings... ex first category group (=name column) with as subgroup phase mentioning for the items in this category (stacked items in the column by category). Currently not possible to see this in the chart widgets. Solution offered is…","categoryID":349,"dateInserted":"2023-06-23T12:35:05+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T14:40:59+00:00","insertUserID":105276,"insertUser":{"userID":105276,"name":"Ilse Ickx","url":"https:\/\/community.smartsheet.com\/profile\/Ilse%20Ickx","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/25\/36\/n2536b42cfc3ef8ddda62c4bbbfb06667.jpg","dateLastActive":"2023-06-23T12:35: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":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":2,"hot":3375056764,"url":"https:\/\/community.smartsheet.com\/discussion\/106820\/stacked-column-for-two-dimensional-view-combining-2-groups-in-one-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106820\/stacked-column-for-two-dimensional-view-combining-2-groups-in-one-column","format":"Rich","tagIDs":[292,363],"lastPost":{"discussionID":106820,"commentID":381985,"name":"Re: Stacked column for two dimensional view, combining 2 groups in one column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381985#Comment_381985","dateInserted":"2023-06-23T14:40:59+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":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106750,"type":"idea","name":"Portfolio Management: Team member part-time availability on Projects","excerpt":"I need the ability to set part-time availability for a team member to specific projects, i.e. working Mon-Wed on Project A and Thu-Fri on Project B. For each project and each team member you could set working days, that would solve this problem. I have a team member in high demand, between two projects an agreement was…","categoryID":349,"dateInserted":"2023-06-22T02:36:38+00:00","dateUpdated":"2023-06-22T04:15:08+00:00","dateLastComment":"2023-06-22T08:22:54+00:00","insertUserID":154130,"insertUser":{"userID":154130,"name":"rshiers","url":"https:\/\/community.smartsheet.com\/profile\/rshiers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDnTaRzNqD0!w28qv0IRvXo!4Gl7IBwphF9","dateLastActive":"2023-06-23T05:49:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":154130,"lastUserID":162621,"lastUser":{"userID":162621,"name":"Gmosedale","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Gmosedale","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nUDo_9-vCQo!e5kox3O7Izo!Q_5KCuITavv","dateLastActive":"2023-06-22T13:18:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":47,"score":1,"hot":3374825072,"url":"https:\/\/community.smartsheet.com\/discussion\/106750\/portfolio-management-team-member-part-time-availability-on-projects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106750\/portfolio-management-team-member-part-time-availability-on-projects","format":"Rich","tagIDs":[319,363,440,468,505,507],"lastPost":{"discussionID":106750,"commentID":381681,"name":"Re: Portfolio Management: Team member part-time availability on Projects","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381681#Comment_381681","dateInserted":"2023-06-22T08:22:54+00:00","insertUserID":162621,"insertUser":{"userID":162621,"name":"Gmosedale","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Gmosedale","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nUDo_9-vCQo!e5kox3O7Izo!Q_5KCuITavv","dateLastActive":"2023-06-22T13:18:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"},{"tagID":505,"urlcode":"scheduling","name":"Scheduling"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-24T15%3A59%3A16%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":137,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">