-
Multi-Sheet & Few Clicks
I have an assessment sheet where 2 different rating columns are linked to the rating key at the top of the column. Would it be possible have the Rating Key Sheets linked or formulated so that when a rating is selected on the key, it'll enter it into the cell on the Assessment sheet? Does anyone have any suggestions / best…
-
Information in cells mysteriously disappears
When my smartsheet is open and I am not doing any editing, I find that cells mysteriously empty themselves and are marked as changed. The RYG balls also just disappear in the priority column and are marked as a change. Sometimes it is impossible to restore the information as it keeps reverting to being deleted. Only one…
-
Freeze top two rows
Is there a way to freeze the top 2 rows of a SmartSheet? I have data in the 2nd and 3rd row that corresponds to the header and I'd like to maintain visibility but have yet to find a way. Thanks!
-
create a location updated index from 1-10
I need to create a count of 1-10 that always stays at the top of the column in the correct order even when the sheet is sorted and when web forms are used to input information to the top of the sheet. Sounds simple but I have no clue how to do this without drawing a circular reference and without the ability to reference a…
-
Linked Sheets and Dragging Rows
When dragging rows to another sheet, is there a way to keep the information from the Parent sheet which to information is being pulled from? This would obviously automatically create linked cells back to the parent sheet that the information is dragged from. Is this possible? Current Process: My company is basically trying…
-
Selecting specific columns for alerts & reminders
Is there a way to select specific columns for displaying on alerts? Currently all columns display on the alert including a column that I have for my own use. Thanks, jerry
-
Features that Smartsheet Should Add
I am sure that most of you have a list of things that you would like from Smartsheet. I have a short list to get us started. Lets add to this and see if they can make it happen! 1 - Ability to paste more than 50 rows at a time. * 2 - Extend the 5,000 row per sheet limit. * 3 - Ability to create a new sheet based off of a…
-
% Completed and Task Finished
I would like to have the % completed set automatically to 100% when the Task Finished is checked. Any suggestion on how to do that? First smartsheet struggles...
-
Multiple selections
Is there a way to create a multiple selection option in a column? Was considering Checkboxes that could be linked to the selection by typing next to it or drop down options with ability to select multiple choices? Please let me know if anyone has created something like this or if there is an option to do something like…
-
Auto-fill form/cells when a certain item is selected from a drop-down
I was wondering if it is possible to auto-fill cells based on an item that is selected from a drop-down. I am trying to create a form for our subcontractors to upload submittals and I wanted them to be able to select from a drop down list what they are submitting. I.E. Product Data for Paint, or Samples for flooring. Once…
