-
Links in templates that can create a link on creation to a set sheet
I have a request that may already be possible so if someone can assist would be great. If not possible I believe it would be a great new feature.! We create a new sheet for each of our manufacturing jobs from a template. When this new sheet is created we then have to copy link the first row of the job sheet into a WIP…
-
SMART Objectives Template
Hello, I tried searching for ready SMART Objectives Template. Any hints?
-
Change Control Automation for I.T.
I would like to create and automatic a change control process for I.T. As the VP MIS I want workflow with control criterias build in based on the change requested. E.G. if its a level 1 or a critical system or downtime etc. It would come to me. E.g. if it's an update or level 2. I can go to my I.T. manager. Is that posible…
-
Reports
My company currently uses Device Magic Forms to do daily reports for people to communicate from the field to the office. We then have to take what's on those forms & re-input that information into Smartsheet to track our projects. This is a time suck on our company, so we are trying to directly have all of this on…
-
Share sheet as a copy - Consolidation
Hello everyone, Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators. The idea is : * I build a main spreadsheet, and I want multiple collaborators to fill this sheet individually * I want to keep track of all the status of certain indicators for each…
-
Calendar view from multiple sheets
HI I am new to Smartsheet and I basically want to use Smartsheet to create a schedule for my business and life to be seen in a calendar and Gantt view. Before creating my sheet/s I am in a dilemma if to create a different sheet for about the seven different projects constituting my business, or to create one sheet. The…
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Best "infrastructure" columns for portfolio reporting
I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc. I current have automated checkbox hidden columns for parent, child, ancestors, milestones, status (based on due date). What other hidden columns do people include in…
-
Copying Rows
I'd like to be able to add 1 row to multiple sheets at the same time. All of the sheets are from the same template, so all columns are identical. The best thing I have found so far is to create the row, then copy it to 1 sheet at a time, but it's still very time consuming. Any ideas?
-
Global Find and Replace for All Sheets in a Workspace/Find and Replace Column Name/Type for All Shee
Is there a way to perform a find and replace on all sheets in a workspace without loading each sheet? Is there a way to perform a find and replace for a column name or a column type for all sheets in a workspace?