Sign in to submit new ideas and vote
Get Started

Increase the limit of rows per sheet

Patricia Pereira
Patricia Pereira ✭✭
edited 03/30/23 inSmartsheet Product Feedback & Ideas

I collect a huge number of data in each of my sheets (Time tracker, task by task) and every 15 days I need to move them to a back up file. Would that be possible for Smartsheet to increase the limit of rows (Similar with excel maybe?) per sheet in order to avoid this backup creation every 15 days? I would like to have the consolidated data in one place, and even though we can do that in a report, all the time when a new file is created I need to add that to the report (which might lead to mistakes). Also, not everybody is able to filter in the report (as it changes everything right?).

Share on Facebook Share on Twitter
5
Up
5 votes

Idea Submitted·Last Updated

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi@Patricia Pereira

    I hope you're well and safe!

    Have you explored using the Premium App, Data Shuttle / Data Table?

    Is that an option?

    I hope that helps!

    Be safe, and have a fantastic weekend!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    ✅Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • christopher1125
    christopher1125 ✭

    extend the capacity of a single sheet to more than 20k rows. Even extending it to 30k would help but this capacity limit is very restricting in large organizations with large, long term projects.

    · Share on Facebook Share on Twitter

Categories

2023-06-27T19:13:54.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":108187,"type":"idea","name":"Cell-level Comments","excerpt":"Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads \"Cell\" next to the \"Row,\" \"Sheet,\" and \"All\" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…","snippet":"Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads \"Cell\" next to the \"Row,\" \"Sheet,\" and…","categoryID":349,"dateInserted":"2023-07-27T15:06:03+00:00","dateUpdated":"2023-07-27T15:07:29+00:00","dateLastComment":"2023-07-27T15:06:03+00:00","insertUserID":149231,"insertUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":149231,"lastUserID":149231,"lastUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":14,"score":4,"hot":3380942012,"url":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","format":"Rich","tagIDs":[319,363,391,441,507,566],"lastPost":{"discussionID":108187,"name":"Cell-level Comments","url":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","dateInserted":"2023-07-27T15:06:03+00:00","insertUserID":149231,"insertUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+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":4}],"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":566,"urlcode":"idea","name":"idea"}]},{"discussionID":108153,"type":"idea","name":"Controlled data: Create Rows but not Edit OR Edit Rows but not Create","excerpt":"prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit but stop them from creating new ones.","snippet":"prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit…","categoryID":349,"dateInserted":"2023-07-26T23:06:59+00:00","dateUpdated":"2023-07-27T11:50:10+00:00","dateLastComment":"2023-07-27T11:53:06+00:00","insertUserID":81486,"insertUser":{"userID":81486,"name":"Trish Dillon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Trish%20Dillon","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ejFZp_HtGHw!wf9YcMXtCfo!EieK1GzsuNz","dateLastActive":"2023-07-27T17:04:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":1,"hot":3380872505,"url":"https:\/\/community.smartsheet.com\/discussion\/108153\/controlled-data-create-rows-but-not-edit-or-edit-rows-but-not-create","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108153\/controlled-data-create-rows-but-not-edit-or-edit-rows-but-not-create","format":"Rich","tagIDs":[219,363],"lastPost":{"discussionID":108153,"commentID":387483,"name":"Re: Controlled data: Create Rows but not Edit OR Edit Rows but not Create","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387483#Comment_387483","dateInserted":"2023-07-27T11:53:06+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":108141,"type":"idea","name":"Automatically Update Numbers in Countdown Formula","excerpt":"Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.","snippet":"Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools…","categoryID":349,"dateInserted":"2023-07-26T20:05:36+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T11:38:35+00:00","insertUserID":164136,"insertUser":{"userID":164136,"name":"mp_12","url":"https:\/\/community.smartsheet.com\/profile\/mp_12","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-26T20:02:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":3,"hot":3380861351,"url":"https:\/\/community.smartsheet.com\/discussion\/108141\/automatically-update-numbers-in-countdown-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108141\/automatically-update-numbers-in-countdown-formula","format":"Rich","tagIDs":[219,319,334,363,391,440],"lastPost":{"discussionID":108141,"commentID":387478,"name":"Re: Automatically Update Numbers in Countdown Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387478#Comment_387478","dateInserted":"2023-07-27T11:38:35+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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":3}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-06-27T19%3A13%3A54%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":167,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">