-
True Sheet Backups
We are trying to create sheets to track the engineering, purchasing and production tasks required to build a large piece of industrial machinery in a small shop. The may be 30 jobs in process at a time and each job may take several months to complete. Each job will have its own sheet and have up to 150 lines. To schedule…
-
Limitations on design - Can I put a forumula in a cell in a date column
Only a couple of days into the trial and I was looking at creating some KPI's for a Sight. Based on what I'm seeing, the underlying calculation MUST exist on a sheet somewhere to be pulled into a sight. The problem I run into is if on a sheet a column is a date or drop down etc. and I want to use a cell in that column in a…
-
Why can't I see zeroes?
I've got a long formula that determines an IP address for a computer. That formula should result in a formula for an IP address that looks like this: 10.20.12.32 However, when there's a zero entry, SmartSheet is omitting the zero, so the result looks like this: 10..12.32 I need to show the zero! If I type a zero in a…
-
Please advise on best way to set up a SS
-
smart change of column name
Hi, i need to change several column names in my smartsheet. I have entire workspace built around this sheet, using it as data source. I have multiple reports that show/filter on this column, and if i simply change the name, reports stop working. is there a smart way to update column name everywhere? or somehow get a list…
-
Data shuffled after I save
Hello all, I have a sheet shared with 7 people. Almost everytime I save there are multiple rows that are randomly shuffled into different spots on the sheet. I have no formulas or macros... I thought I would throw this out to the community, any ideas?
-
Row limitation?
Is there a limit as to how many rows I can have in each sheet?
-
Creating a Workspace with already shared sheets
Hello everyone, So I would like to know wether I need to share a workspace that I have created with sheets that haave already been shared. I have shared 2 x Inventory lists with the team (we are a small team so that was simple) however now that I have over 20sheets in my list I am creating workspaces to better collate…
-
Duration in parent row not calculating
I have a parent row that is indicating duration of its child rows as 78,324 days when in fact it's actually 53 days--February 1 - April 29. (I made sure the dates were all in 2016). I had one row that was showing several thousand days when it was actually 21 days. I fixed that and saved the sheet but the parent row is not…
-
Sorting heirarchy numbers (1.1, 1.1.1, 1.2) in reports
Hi everyone, I am using reports to merge 20 to 30 sheets and sorting them on multiple and different heirarchy columns (containing numbers such as 1.1, 1.1.1, 1.2). This doesn't really work out of the box because the report sort is apparently just a standard natural sort and doesn't recognize this notation. I wasn't able to…
