Can anyone tell me about latest row - column - cell limitations of each sheet in smartsheet please?
A sheet can contain up to 20,000 rows, 400 columns, or 500,000 cells (whichever limit is reached first).
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Wow... that's quite a lot!
Happy to help. 👍️
I am actually having an issue where 400 columns is not quite enough... I have a form with a lot of potential inputs and logic with formulas to process the inputs, reaching 392 columns very quickly, and when I tried to add more, I ran out of space. I feel as if I am forced to use more complicated/larger or more creative formulas to do the same things without using so many columns. Honestly, I'd like to have a higher column limit.
My form sheet has two variations on a similar form one with 29 questions and one with 35 questions, giving a total of 64 questions that take up space on the sheet. Each question has to be able to accept 4 additional pieces of information, in addition to the question response, depending on whether they answer "yes" or "no". The form also needs 5 pieces of initial info from the user. This means the data entered could occupy as few as 34 fields or as many as 180, in the worst, most unrealistic scenario. However, the other columns still must be in the sheet, just in case the user selection requires those columns... The 29 questions version of the form requires 29*5=145 columns. The 35 question version of the form requires 35*5=175 columns. Add the 5 mandatory, initial fields and you get: 145+175+5=325 columns (minimum, just for user input).
Now I have room for 75 columns for formulas which is not a lot considering most formulas will need to calculate a value on a by-question/by-field basis, meaning even for just one formula per question, this will occupy an additional 35+29=64 columns, leaving only 11 remaining columns... Hopefully this demonstrates that however 400 columns is usually a huge number, in some cases, especially large or complex forms, this is not that high of a limit.
If anyone has any suggestions please let me know, and also,...
this is not exactly Smartsheet related, but I tend to crave more open-ended abilities with less limitations that I sometimes experience with Smartsheet, and this ability is basically what programming allows you to do... does anyone have any programming language or tools, etc. recommendations that would allow me to have a bit more freedom to develop larger and possibly more "algorithmic" sheets/applications? I have a good programming foundation, so I am very interested about learning something in this territory to take our company's digital potential to the next level.
We have a spreadsheet with data that needs to be updated/validated twice a year. We wanted to use a workflow, but some owners/approvers of the data have 150 rows to their name. We don't want to flood their email with that many emails or have to go through 150 lines that way. We are working with the idea of sending an…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
We would like to request the ability to add multiple conditions to a Conditional Formatting rule. For example: If Step="Backlog" and Flag=Yes, mark row orange.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.