-
Max Capacity error on sheet w/3,256 rows and 8 columns
I am getting the "this action could not be completed because your sheet as exceeded the maximum recommended size" error on a sheet that I don't think is at the maximum. I have 3,256 rows and 8 columns which, if my math is correct, is 26,048 cells, no where near 200,000. I got the error when trying to add another column.…
-
Formula for summarized health indicators for discrete categories
Hello, Perhaps this has been answered elsewhere - in which case I appreciate being redirected. I am trying to determine if it is possible to create formulae that summarizes a health indicator symbol (Red, Yellow, Green) across multiple rows in a sheet, when further categorized by a variable in another column. So, in other…
-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Rows deleted when deleting columns connected to formatting
Hello smartsheet community, Initially I was tracking completed tasks with a "Done" column which would automatically format the row. After needing to add more options like "Cancelled", "In Progress" etc. I opted to create separate column which contains those options. After clearing all of the "Done" column formatting I went…
-
Exclude sheets from reports based on sheet name?
Is there a way to automatically exclude sheets from reports if the sheet name contains a certain string?
-
Expand/Collapse all functionality
I have set up a hierarchy within several sheets and I'm wondering- is there an Expand all/ Collapse all functionality for the 'nested' rows of data? Refreshing the page doesn't change anything within the sheet that is shared across 4 users. Mendy
-
Comments - Keep important ones on top
Hello, Are we able to lock comments on rows or sheets do that they stay to the top?
-
Overwriting Lines?!?
Is anybody having issues with people overwriting each other in their shared sheets? We have (3) users utilizing the same sheet and adding in lines at any given time and we started to experience some refreshing issues. It just happened again today as a line I created 2 hours ago was overwritten by another user AFTER they…
-
De-Scoping/Deactivating Rows
We need a function where users can de-scope rows, thus deactivating that row and removing its influence on its parent rows. Is that an option via Smartsheet?
-
Date AND Time format
Hi I was wondering if there was / is a way to format a cell to be date and time format? We enter in when we contact a customer for the 1st time and have to track the date and time. It would be nice to do so with one cell where we click the cell and a time stamp of now (but editable) is available. Is this a current feature…