-
Add Custom Image For Trend Widget
Hi, I am able to setup a widget that is link to a direction symbol (up, down, neutral) for my data. What i want to do is have a customer image for each (up,down,neutral). Is it possible to have a conditional statement that will present the relevant image to the widget? I have tried within a sheet, by adding the image to a…
-
Tire Maintenance - Form / Spreadsheet Assistance
Hello All, Today is my first day (YAY!). I'm digging Smartsheet thus far, although, I'm looking for suggestions. I've been tasked with creating a Tire Maintenance Program. So far I've put the basic asset information (Year, Make, Model, VIN, Tire Size(s). Screen shot will help make sense of this. The key part is trying to…
-
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…
-
Criteria for Alerts and Actions Rule
My boss has a Smartsheet set up to send a Update Request 30 days before today. For example row 7 would look like ....=[Due_Date]7 - TODAY() Would this alert still be sent if Smartsheet was down for maintenance at the scheduled time the alert was to be sent, or if there were conflicting "work week/full week" settings?…
-
Adding task line in one sheet and displaying in/moving to another
I have individual sheets created for 4 people (one being mine) where we have lines for all our tasks. I use a Report to consolidate all 4 sheets. However, when I have a new task I want to assign, I prefer not to have to access each of their sheets to add a line. I'd like to add the task line on my sheet and assign the Task…
-
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?
-
Rows missing
I was working in one sheet (with autosave on), switched to another sheet and when I returned the rows were missing - there is no hierarchy/drop downs and it looks like the rows are ´hidden´. Any ideas how I can retrieve the missing rows?
-
Enhancement Request: Allow multiple sheets to be selected for Copy to Another Sheet
I would like to copy the same row to multiple sheets. It would be useful if this could be done using multiple selection instead of click. click. scroll. click. OK. repeat. I would be OK with a limit (5 sheets / 10 sheets) or waiting for them all to process. This request has also be posted to the Form Craig
-
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?
