-
More than one column with the same name in Smartsheet?
I'm new to Smartsheet and tried to add more than one column with same name to my worksheet; got error message saying name was already used. Is there any way to do this? I'm tinkering with Smartsheet and think I may ideally need multiple columns with the same name (Responsible, Project Status) since there are multiple…
-
Calculating Durations
I have columns in my sheet with "Departure TIme" and "Arrival Time" in the format hh:mm Since there is no "Time" Type for the columns, so I had to kep the Column Type as Number/Text I am looking for a way to substract these 2 columns to obtain the duration of the trip. Many thanks for any help
-
Automate archiving of completed tasks
I've copied a sheet of "Current Tasks" so that I can use the copy to archive my "Completed Tasks," otherwise they just fill up my task sheet. I notice that there's a feature for linking cells, but I'm trying to figure out if it's possible to have the rows marked as "Completed" automatically copied to the "Completed Tasks"…
-
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