-
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…
-
Do not add 10 blank rows at the bottom of the sheet
Please STOP adding blank rows to the bottom of the sheet. They are unnecessary and can cause issues with formulas.
-
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…