-
sum column and calculate total to hrs:min
I have a "duration" (used to track time involved) task field that I need to be sum and show on a report as hours:minutes. The column is a drop down field with numbers only in 15 min increments. example: 15 30 45 60 75 90 etc... Appreciate any replies.
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Printing All Comments by Sheet
Hello! Is there a way to print all the comments contained in a sheet? Right now, all I can see is the option to print them row by row. Thank you, Sandy
-
adding service records to a row
I have a plant & vehicle register that I want to add service records to. So each row is a vehicle and I want to keep each service record as a history of the vehicle then I need to export the record for my clients is there a way to do this without adding extra columns?
-
Milestones Report on a Sight
I've got a Report that I'm pulling into a Sight. While in the report, I properly see the diamond symbol for my milestones, yet, once I pull the Report into the Sight, it's showing me the bar, not the diamond. See the screenshots - the one showing the diamonds is when I generate the report. The one with the blue bar is the…
-
Combining Data from Multiple Sheets in a Sight
My team and I are having a problem with the combination of data from multiple sheets showing up in our sight. Originally, we had a couple sheets that all had formulas returning data at the top of each sheet. I then cell linked the cells from these sheets to allow one sheet to add them all together. This then allowed just…
-
Count Past Due Tasks
Hi there - I'm new to formatting / formulas in smartsheet (and excel for that matter) and haven't had much luck creating a formula that counts tasks that are past due. While able to use conditional formatting to visually identify these items I'm trying to roll this up into a project overview; the overview/dashboard -…
-
Setup hour by hour plan for the day of migration
Hi, How can I setup a project plan to capture hour by hour activities for migration activity within the day? 1st task will have the start time, then end time and next task start time will base on the data in duration (hours or minutes). Some tasks could be in parallel and others will be in sequences. Still learning…
-
change task color in filter calendar view
I'm sure this is very simple as I did it for one of my filters but not for the life of me can't figure it out again. Looking to change the color of my tasks in calendar view when I apply a filter. thanks Mike
-
Missing email collaboration
I keep stumbling over my desire to collaborate with team members via email or discussions. Discussions work OK, but I'd call them "Notes", unless I'm missing something (and I hope I am!). For example, if I want to include someone in a discussion many of the other tools I use let me type "@Ste" and it will popup all users…