-
Insert Function Not Working for Checkboxes
This morning, I noticed that the Insert function is not working properly in my smartsheets. When I try to add rows to any of my Smartsheets, a new row is added. However, the new row does not initially contain any checkboxes in columns where the data type is Checkbox. If you create a new row and click on a checkbox cell in…
-
Retrieve deleted data?
Hi, all: I'm a new user of SmartSheet in an organization that has a few other users, and one team that uses it quite extensively. Putting out a question that I think I know the answer to, but here goes: One of the users on the team that uses it a lot recently discovered that he believes that several rows of data were…
-
Best Practices in a large project
I am new to Smart Sheet (and loving it!) I am working with our annual meeting planning which includes everything from location search, contract signing, registration, etc. etc. I can't decide whether this is all one sheet or whether it should be divided into several sections with subtasks. I have played with a bit in…
-
Copy/Paste outside of smart sheets
I often need to copy and paste from and to smart sheets, but find that it uses its own clipboard. Say I have a 9 digit number in an excel sheet, and I want to just bring the info from that one cell into my smart sheet, I will copy from excel, but when I paste in smart sheet, it pastes the last info I had copyied within…
-
moving rows in reports (without using Sort)
Is it possible to move rows around in a report without using the Sort function? I have a report that pulls from 3 sheets, and I want to change the order of the rows from each sheet (not individual rows if that helps). Sorting only changes the order numerically or alphabetically, which I don't want to do. Any ideas?
-
Share only selected sheets from workspace
Hi all, I have multiple workspaces for different customers and I'd like to keep some sheets from there internal and some public, hence share with customers. Apparently I can only share a workspace completely. This forces me to have a lot of individual shared sheets, hence breaking the folder structure I would like to have,…
-
Cell reference formula
How can I create a formula from two columns that will result in pulling in the value from a third column? Column1 (text) = Column4 Column2 (text) = 3 Column3 (date) = Column1 + Column2 Ideal Column3 result = [Column4]3 Please let me know if I can clarify anything, it is a little confusing. Thanks
-
Smarsheet as a payslip app.
Is it possible? I need to automate my timesheet into a payslip afterwards. Tell me how can I do that? Thanks.
-
How to Hide an Obsolete Smartsheet
We've been using Smartsheet for a while now, and we're accumulating a number of completed projects. We'd like to hide the completed projects so as to remove the clutter. If we can't hide a Smartsheet, we would be okay with re-naming it with a prefix that indicated it was compelted or obsolete. If we can't hide it or…
-
I'm a Shared Sheet Editor but Cannot Edit a Column Dropdown List
Hello all! I am a shared editor on a page and need to modify a column dropdown list, but that option is greyed out. Are only administrators allowed to modify drop boxes?
