-
Enhancement Request: Find & Replace in Hidden Columns (Admin)
Allow Replace (Find & Replace) in hidden columns for Admins DescriptionWhen I perform a Find & Replace, I would like (as an Admin) to be able to Replace All in hidden columns. I can Replace All in collapsed rows, which is not quite the same thing, but they are not visible when first searching. OK, the hierarchy expands…
-
Enhancement Request: Add Filters to Column Menus (special columns)
With the 2018-01-17 release, we can now filter on attachments/comments/locked rows (yes or no). Please add the first two to the associated Column Menu for those columns. Also, add filters for the Icon column (resource issue, reminder, pending UR) and add that to its Column Menu too. If the Filter Menu is not shown, adding…
-
Formulas and Referencing Sheets
So with the new referencing sheets feature (at least I think it's new) is it possible to have one sheet that would be the master for all summaries and metric information rather than roll them up into extra rows at the top of each sheet?
-
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?
