-
Free Users and Reports
Our company has many free users as that is all they require with a limited number of licenced admins. My issue is regarding the Reports. As an admin I can create and edit happily but my free users are suddenly unable to change the filters. I've looked up free user access and Smartsheet specifically says they can still edit…
-
Report Summaries Averaging RAG Status - Functionality Request
A major limitation I am currently finding with Smartsheet is the ability to be able to pull average RAG status summaries into Report Summaries for charts and consolidated reporting across multiple projects. For example - 10 project plans with 5 business units where I need to track % complete and RAG Status (which is based…
-
Report Summaries - RAG Status Summary - Functionality Request
A major limitation I am currently finding with Smartsheet is the ability to be able to pull RAG status summaries into Report Summaries for charts and consolidated reporting across multiple projects. For example - 10 project plans with 5 business units where I need to track % complete and RAG Status (which is based on…
-
Master File sending selected columns to new consolidated sheet
Hello all, I'm quite new to smartsheet and I'm trying to find advice on consolidating data. I have a sales report that comes out of my ERP that has info on orders for multiple customers, sales data, delivery dates and plus loads of extra data. I wanted to upload this master file once a week to smartsheet and then have…
-
Direct access to a sheet via a report
How is it possible, in a report, to access the referenced sheet directly from a report? Thanks for your help.
-
Creating Project Timeline Visualizations-Not Gantt View
I am wondering if anyone has experience with creating a high-level project timeline view to put on a dashboard--and I am not talking about a Gantt view. What I am trying to do is avoid my customer from having to continue producing PowerPoint slides manually of the data they are managing in Smartsheet. Ideally, they would…
-
Sort by Sheet Summary fields in Row Report
Hello, I am curious whether there is a means by which I can use a Sheet Summary field to group and/or sort rows in a Row Report. For example, I want to give a group of sheets a "Priority" field (1, 2, 3, etc.) and then in a Row Report, be able to sort rows by the priority number associated with the sheet where the rows are…
-
I am trying to book an Orchestra using Smartsheet Forms and Sheets, any ideas?
The form needs to go out to the pool of musicians and poll their availability. Then the availability needs to be able to be quarriable to book musicians by part. For example, I need the following parts covered each day: Flue, Trumpet, Trombone, Tuba I need a form that can go out to all the flute platers and they select the…
-
Creating report to show all Parent Rows based on Child Row
I'm trying to create a report to display all tasks assigned to current logged user. In the report, I want to see all the parent rows displayed for the assigned tasks for the logged user. e.g. If I create a report of current logged user (let's say Jane) for them to look at the assigned tasks (primary column), then how to…