-
Gantt & Calendar Views on Reports
Thank you Smartsheet for the new feature allowing Gantt & Calendar Views on Reports! Best thing since sliced bread and dental floss!
-
New in Smartsheet: Gantt and Calendar Views on Reports, Better Update Requests, and More
Smartsheet’s newest improvements give you more power to choose the level of detail you want to share, both within and outside your organization. Send a project rollup to executives using Reports, now complete with Gantt and Calendar Views, or share a single row to an external collaborator for a quick status update with…
-
Create time card from project schedules
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
-
Calculations in a report
I'm trying to create a report where i only see records with End Date = this week. (so not 'the coming 7 days' or something, only this week#) I have column 'Week# that shows the week# of the field 'End Date' in my sheet =ROUND((([End Date]1 - DATE(2015, 1, 1)) / 7) + 0.49, 0) in my report I defined in the 'What' part:…
-
Counting in summary reports
Hi All, I'm interested if anyone has found a good way to use sheets or reports to count fields meeting a given criteria from another sheet. In my particular case I have one sheet that lists (and links to) project sheets. I would like to have another sheet/report that counts how many projects are green/have a particular…
-
More A-Z Sort options.
Is it possible to add more sorting options. right now we only have three drop down bars, I need four. How can I add more?
-
Using or not using hierarchies
For sales I have been advised not to use heirarchies to group things by areas like likelihood, potential size, stage of progress, etc, because once they're a few pages long it's a bit unweildy. I was advised to use no hierarchies for a sales pipeline and instead rely on Reports for all of that. But I see that with the…
-
Net Promoter Score
I have a survey web form. One of the questions is "likelihood to recommend" with a dropdown list of 0 - 10. I'm trying to build a report from this web form that will automatically calculate the net promoter score (% promoters (9&10s) - % detractors (0-6s)). I know how to build the formulas to calculate these, but I don't…
-
Is there a way to apply conditional formatting or grouping to reports?
Looking for a way to utilize the reports functionality. It would really help to have conditional formatting capability as well as grouping functions.
-
Permission to view a report in one Workspace that points to a sheet in another Workspace
I would like to create a report in a Workspace that is view only to a group in that Workspace, and have this report pulled from a sheet in another Workspace that this Group would not be allowed to view. This does not seem to work, as the Group permissions don't allow this report to be run since this group is not allowed to…
