-
how to count rows under a parent and sub parent(s)
I have a sheet that is grouped by product categories. Underneath that category are products, and within/under a product are projects that are active and/or planned. So imagine the structure of the sheet is: Product category Product A Project A Project B Project C Product B Project A Project B I would like to display a…
-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Sheet scalability
I have a sheet that I built for year-end performance reviews. The sheet is designed for one person. My company has 50+ employees and it would be great if I can run some sort of macro/app that would take the sheet and replicate it 50 times with each sheet adding a new name from a contact list. Any ideas? Thanks Ian
-
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…
