-
Control Center - Global Update: Adding Metadata to Existing Project from Intake Sheet
I am trying to perform a Global Update to all of our existing projects to include additional data for us to report against that is currently captured on our Intake Sheet. I have been successful in adding this additional reporting data to newly provisioned projects but am unable to now incorporate it into each existing…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Material Tracking
Please help haha It is difficult to put into words exactly what I am trying to accomplish, but I'll do my best. Please ask questions if I'm not being clear enough. Example: I have a material column for material that is being delivered to a job site (Sheet name is Delivery Tracker). Each cell in the column is an individual…
-
Hiding rows
I would like to be able to hide rows can only find option of hiding columns. It would be especially helpful if hiding rows option could be added to conditional formatting.
-
Formula Help
Can anyone help with this formula? It works in excel but I am getting Unparseable error in smartsheets. =IFERROR(IF([QTY]@row,<>0,[QTY]@row*[Production Rate]@row),IF([Linear Feet]@row<>0,[Linear Feet]@row/[Production Rate]@row,[Sqft]@row/[Production Rate]@row)),0) Thanks for any help
-
V lookup in sheet summary
Is there a limit to the number of V lookup reference sheets I can use on a sheet's summary tab? It seems like when I change a field to reference 'Sheet A,' and save, the other fields also change to 'Sheet A' even though I indicated 'Sheet B' for that field.
-
Automatically alert when project goes beyond an install date
Hi, We have multiple (50+) projects and once the project commences an install date with the customer is fixed. I have set this up in smartsheet, to have the install with no prior dependancies. What I wont to do is set up an alert when the project build is after the agreed install date. Any ideas on how I can do this?…
-
Is having multiple 'events' on the same row or specific days highlighted possible on Gantt view
I'm creating a Gantt chart to monitor and plan my progress for a thesis I am writing. I have the various stages of my thesis with their sub-projects indented under them, so my Gantt chart is becoming quite tall. I also need the days of my other deadlines highlighted on the Gantt chart, so I can see where my deadlines will…
-
How to add new sheets/dashboard to all existing projects on Control Center
I have created/provisioned a few projects on Control Center and realized that we wanted to add couple more sheets and dashboards to all new projects as well as to all existing projects. It doesn't seem like the Global Update can achieve this as it can only edit information within a template in the blueprint source folder…
-
Single-Select drop down menu autofilling options
Hi, I am attempting to select an option from a single-select drop-down that will auto-fill the next column. I have loaded the formula as a one to one basis, i.e. if 'this person' is selected, populate 'this manager' in the next column. However, I need it to be across multiple employees. So if, this person, this person, or…