-
Limiting editable access to certain users
Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Add a New Task with all the sub rows
I have a sheet where I have all my projects and then sub categories indented underneath it. Is there a way I can easily add a new project that will create automatically add the sub categories?
-
Grouping and Sorting
Hello, Coming from a project planning background I am used to being able to chose how I group my plans. Is it possible in smartsheet to group say by who a task is assigned too? I understand the way the indent function works and the way you can filter on "Assigned Too" if I wanted, but for eg I might want to view my full…
-
Referencing sheets
I am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filter what is needed (to a point) with reports but it still doesn't give me the end result I need. Here is the breakdown in a…
-
Developing a Matrix Questionnaire
Hello, I am hoping someone can help me design this type of Survey Form to send out to my work employees. I would like to ask them to pick an answer (that I give them), by selecting the radio button. It seems easy enough however, I do not see this. I have attached a screenshot. If you know how to do this, I would really…
-
Is there a way to NOT auto number the 1st Row? ...and other SUM row questions.
I am using the first row for totals and it is throwing my auto numbering system off. Is there a way to have the auto number start on row 2? Alternatively, if I put my totals on the last row, the web form will populate new rows below my totals. What are some best practices to display my column totals on a continuously…
-
Contacts and Contact Groups
Can you share contacts or contact groups with other smartsheet users? Similar to how you share a filter or another way?
-
Does Smartsheet have voting buttons for "voting up" ideas?
Looking for an interactive way to vote, like Tricider or Stickymoose, but within Smartsheet. Thanks!
-
Conditional Formatting Dates
I am trying to conditionally format dates that are in footers of grouped cells. The purpose is that I want to conditionally format dates in those cells that are 7, 14, and 30 days ago from today's date. The context is that these days are our initial contact date. If we go 7 days without contact (changing the date to the…
