-
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?
-
Sheet Sharing
I have a sheet that I "save as new" weekly in one workspace. The workspace has 7 people but the sheet I share weekly has 5 additional people who do not need to be shared to the entire workspace but do need to see that sheet weekly. Any advice on how I can keep these people saved to the sheet without having to add them each…
-
Is there a way to add hours and minutes in a column?
This is the only thing holding us back form using smartsheets. Is there a way to add columns such as the one in the attached picture and come out with the correct answer for hours and minutes?
-
Need to reverse new currency formating
How do I reverse the new currency formating. All our sheets now show the cells formatted as currency are now cluttered with the country prefix. Instead of a simple $ sign it is now CA$. I need it removed in all our sheets or to be able to reformat all currency cells to 2 decimal # in one step!.
-
Navigation between sheets
I am starting to use smartsheet more and more but one thing that hangs me up is the navigation between sheets. I utilize the sheet tabs at the top of the page but I generally have more open that fit in the space provided and they also typically do not keep any specific order. What I believe would help speed up navigation…
