-
Feature Request - Sheet archiving offline- or Unlimited sheet limit.
Since I use Smartsheet for everything at work and home, the number of sheets pile up. One can get up to the sheet limit fairly quickly. I use Smartsheets for job tracking and article outlines so the number of sheets piles up pretty quickly over time. Some of the sheets I no longer use on a regular basis but want to keep…
-
Past Due Reports
GOAL - Tasks Past Due Report for Multi Sheets I have several sheets with the columns set up as seen below: (Type 1) Rows have Tasks with a Contact under Assigned to, "Required" column has a symbol and % Complete is not required so it's left Blank. (Type 2) Rows have Tasks with a Contact Under Assigned to, "Required" column…
-
Constructing User-proof formula
Any ideas on constructing more user-proof formulae? I'm having trouble with users inserting rows in a sheet versus appending new rows at the bottom. Locking rows doesn't prevent an insert (would be nice if a non-admin user couldn't insert when adjacent rows are locked). I've used the following formula to ensure the first…
-
Activate filter by pressing enter
Has anyone had the same problem since the new Filter was released... you cannot activate the filter you have just created by pressing enter. you have to click on 'APPLY' with your mouse or touch screen. Smartsheet - the new filters are amazing... but we really need the option to activate the filter on 'enter' not having to…
-
Export List of People a Sheet is Shared With?
Is there a way to export a list from a sheet that shows the user's security level? And if so, can this list be imported to a new sheet so that each team member does not have to be added manually to the new one? This is not necessarily for a template that is used repeatedly. It is a group of about 150 people, various…
-
format text in cells
Definitely need the ability to format text within cells! Ie, make some red, some bold, some underlined. See you can even do it here (ok, except the red), but not in SS's! Please add this function!
-
Active Sheet Format Updating from Template
All, My org manages product delivery lifecycles. We currently copy a process checklist template (sheet) for each new product delivery. This checklist also captures dates and data points. Idealy there would be a way to actively update format of the checlist template sheet (additional rows added as we fine tune the process)…
-
Adding checklists to a project
In my project with gant chartsd and ependencies, I would like to add a task, e.g., "Set Up Vendors". As a subtask, I would like be able to add 10 vendors. Ideally then, as each vendor is setup, I want to "checkmark" each vendor. Once all 10 vendors are checked, then the task can be marked as complete. Is this possible?…
-
Can I use cell history to calculate how much time has taken between two non-date cell types?
Hello SS Community, I have a sheet that is used by medical professionals. We need to calulate the time between a cell that is filled out when a patient arrives, and one that is filled out when they leave. The cells are text based and not date type, nor are they cells where the user is typing in a time (so I cant simply…
-
Consistent sort and filter
The ability to automatically sort and filter is a must for us. right now we have to go through the pain staking task of removing the filter, setting up the sort, and then adding the filter back for each item we add through the web form. How do we automate this as it's 100% unnessary to ask all of our designers to do?
