-
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…
-
Transferring ownership of Workspace easily?
Is there a way to transfer ownership of a workspace without having to remove the current owner from the workspace? They still need to own specific sheets, and edit others in the workspace, but do not need to own and administer the workspace anymore.
-
Formula Only Column
Hello! Can the entire column have the formula in each cell without it marking it as a new row? Status Column = Drop-down Column State Column = Symbols Column (with red/yellow/green symbols) Goal: State column automatically updates based on Status column. Example: If Status column says “sent for approval” then the my State…