-
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…
-
Show or hide columns by grouping (in Grid View)
Similar to the 'Group' and 'Ungroup' functionality in Excel, it would be helpful to select multiple groups of columns then have a way to categorize them as a group, then be able to toggle/filter the Grid to show only the columns desired. Use case example, you have columns for each month of the year and multiple years but…
-
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…
-
Copy and Paste Column's
Need a way to copy and paste columns from one "standard columns" sheet to new sheets. This would be similar to a template but more flexible.
-
Delete Rows using an Automation
Please create automation to delete Rows. Using the move rows automation, we are able to move records to an archive sheet. The problem then becomes we have to manually delete records from the archive sheet.
-
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…
