-
Report Sorting by Sheets Names Starting with Numbers Out of Order
Hello, I have a report being built off of 10 different sheets. Each sheet name is prefixed with a number and followed by the name (1. Project Name, 2. Project Name, etc). All was working well and the sheets were being sorted in the report by sheet name as expected until I came to sheet #10. Now the report sort order is 1,…
-
Schedule automatic reports for updates
I have project teams of 10-20 people and each are assigned tasks. On a weekly basis, I want to auto-gen a user-specific report of their task items and send a request for updates on all items. For example, every Tues at 11 am, I'd like to have a report generate that contains all assigned items where the % Done is less than…
-
How often does a report update?
We are using a Smartsheet Report to upload data into a third party system. We are curious as to how often the Report will update. Example: If we open one of the Smartsheets that feed the Report and make a change and we do not open the Report, then when the third party system pulls data from that Report, will it have the…
-
Vacation/Out of Office causes resource over allocation?
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show as if the person is 185% over allocated. (for example if it is 85% project and 100% vacation) Is there any workaround on…
-
Action Row Indicators in Reports
I have created a report that shows resources in a Gantt view. This works well however, what is not available is the useful row indicator showing a user is over utilised on a day. Using the resources views is OK but it doesn't make easy reading as you can't see the tasks and only the sheet name. Anyone got a workaround for…
-
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.
-
Reports Not Functioning
Is anyone else have problems with reports not functioning properly? The data from my master files and not pulling into the report as it normally did in the past. I confirmed all criteria and nothing has changed.
-
Enhancement Request: Allow Wrap to be turned on in Reports
I often come across columns in a Report that I would like see with Wrap turned on. These are sometimes (usually) columns/cells that I do NOT want to turn Wrap on for the source Sheets. Reports inherit their formatting from the underlying Sheets* and I realize this may be a difficult change to implement. However, I also…
-
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?
