-
Merged: Creating & Locking New Sheet or Report Views
This discussion has been merged.
-
Set Default View in a Shortcut Widget
When a shortcut widget in a dashboard is linked to a Smartsheet item, those links always default to the grid view of an asset (if it's a sheet). If you are trying to promote gantt, card, calendar, or the new Board or Timeline views of an asset, it would be great if the user configuring the shortcut widget had the option to…
-
Merged: Better conditional formatting options
This discussion has been merged.
-
Best Way to Tailor Forms for a Specific Person on a Contact List?
For example, I have different teams providing updates in a Grid view. I would like to have multiple versions of a form where each person on the contact list gets a form that already has their team selected. Any advice on the easiest way to set this up? Thank you!
-
I want to be able to hide my formulas from being viewed when you hover over the cell.
I have a sheet that has a lot of complex formulas and is used (and edited) by many users. When the users are referencing the sheet, the formulas show up and get in the way of reviewing the data. Is there a way I can hide the formulas from popping up when others are using this sheet to edit? All of the columns with the…
-
(Grid View) Cell and Column Data Validation Rules
What if we could add required value and data validation rules to any text/number columns. This could be to enforce either blank or a value matching the formatting, but would help with data validation across the board. My use case, in particular, is that I pull in data from Smartsheet to a data model and data visualization…
-
How to count total number of requests submitted?
Hi, I am trying to find a formula to count the total number of requests submitted in my grid. I want the formula to count the number of request ID's displayed. I want to use this number so I can display a metric on the dashboard. I also want to use a formula to count the number of "In Progress" requests and use this to…
-
Rolling "instagram" Style View
Current Smartsheet views are limited to Timeline, board, grid, card, and calendar views. I would like a "instagram" style view which would incorporate photo and video attachments with additional info below from the sheet. This would be extremely helpful when using forms to generate content for media and communication…
-
When You Create A New Column At The End of A Sheet, Adjust To Include It In The View
I am wondering if its possible so when you add a new column to the far right side of a sheet, when it is created the sheet auto-adjusts to ensure the column is in view. It is a big pain to continue needing to scroll to the right when I am entering like 30 columns at a time. Would be AMAZING if the sheet would scroll to the…
-
Smartsheet as Data Entry Form with Intertwined Filters in Drop-downs
Hi. I need to upload an Excel spreadsheet to have some of the columns there filled with text and dropdowns. The problem I am facing is that I would need the different dropdown filters to be intertwined (that is, if I have two columns with one named Continent and another one Country; making sure that when I do select in…