-
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…
-
Scroll Bar Size
It would be fantastic if we could either increase the size of the scroll bars (bottom and right) or show them permanently. It can be so frustrating trying to get the scroll bars to engage, especially when referencing another sheet in a formula.
-
Can logic be added to a sheet?
My boss wants to create a sheet that includes 4 different profile forms. I'm curious if this is even possible. Basically, we have 4 different excel docs that are profile forms, we want to try to combine these forms on a grid in Smartsheets but we want the fields to auto populate depending on which profile form is selected.…
-
Allow auto scrolling with middle button mouse click
Allowing using the middle button on the mouse to start an auto scroll on the grid view. Some of the sheets are quite wide, and it would be nice to not have to use the scroll bar at the bottom to move left/right.
