-
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…
-
How to organize smartsheet for multiple column updates monthly
I would like some suggestions on how to use smartsheet for my application which collects data for a metric. For my application, I have 50+ projects that are spread across multiple businesses. For each project, each month the owner needs to enter 4-5 data values to report the monthly metrics for their project. We need to…
-
Retrieving Lost Data
I realize that this is a shot in the dark and I know it wasn't possible in the past, but does anyone know if it is possible to retrieve data that was deleted from a sheet after the sheet was then saved. If there's a way to get this back then let me know. Thanks!
-
How to submit a Template to be Shared in Template Category?
Hi! I have created a tax season client template that would be a great addition to the finance category. Travis had requested that I share so please advise on how I can share with the SmartSheet community. Thanks!
