-
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?
-
Calculate health of a smartsheet project.
I have created a smartsheet from a project management template. Start and Finish Dates, Durations, predecessor, % complete, are all working well. I can easily calculate the health of completed tasks by allowing a project manager to change the % complete and look at over all weighted averages of those complete tasks. That…
-
Multiple vendors and corresponding part numbers
We are using Smartsheet to manage inventory. We purchase the same materials from multiple vendors, depending on pricing and availability. Is there a way to list the multiple vendors with their corresponding part numbers without indenting lines for each vendor below each and every item? The time required for that solution…
-
Use custom template via the "create new / +" button
Is there no way to use a custom template via the "Create New / +" button on the tab bar instead of going to Home and selecting it over there? Thanks.
-
Type selected - allows certain columns to be updated
The checklist type smart sheet will be setup with columns called Vendor, Type, Doc 1, Doc 2, Doc3. What I want to do, is depending on the type selected for a particular vendor, the doc columns will grey out for those doc types needed for that specific doc type. For Example: Vendor 1 Type Critical All doc type columns would…
-
Populating a sheet from a Webform
Is there any capabilities regarding populating multiple lines of a sheet from a web form? My company uses Smartsheet as an AP tool where vendors submit there invoices through the web form I created. My company has over 150 sites nationwide and over 300 globally, so some vendors we have are global as well and invoice 50-100…
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Ticketing Sheet: Update Request to Group?
I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. How do you request an update to a ticket (row)…
