Please add the ability to use more sort levels when sorting sheets and reports. It's pretty easy to run up against the limit of only being able to sort by 3 columns. In my personal experience there are cases I've hit where we would need to use 5 columns to have a sheet or report sorted in the most logical order. I'm sure…
Am I able to freeze row 1 on a sheet so when people fill out the form, the data imports underneath row one? OR Can I change the colours of the header row like I have with row 1?
Is there a way to set a date requirement for a form submission on a Smartsheet? Meaning, I have a Smartsheet that is for event request. There is a form that auto populates this Smartsheet. I want to set it where the submission date must be at least 2 weeks (14 days) prior to the requested event date on the form. Is this…
I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the current row entry. I was getting a #circular reference error, I tried IFERROR and some recommendations on other posts, but…
Hello I have 2 sheets a master sheet and a sheet that is populated from a form. the first few columns on the master sheet are filled in via form, that data is then used for estimation which is filled into the second form. the data from the first form is added to the data from the second form on the second sheet using…
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
I frequently use the "favorites" star on the left to quickly go to my sheets. I have had some trouble quickly accessing the sheets because I scan with my mouse up and down the list. Each sheet creates a pop-up when you hover over it. This makes it difficult because I end up clicking the pop-up instead of the sheet I…
I have a consultant, who does not have a license, who I gave Sheet permissions 'Editor-Can Share'. They attempted to share the Sheet and received an error message saying that they do not have "sufficient permission to modify sharing on this item". As far as I can see they have permissions, so I don't know why they are…
Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text…
