-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Tracking resources, their hours per task and their hourly rate
Using a standard project template, is there a way to track resources (licensed and non-licensed), their hours per task and their hourly rate. This way I can calculate their total hours worked x rate to get their cost.
-
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…