-
Convert Numbers to Text so I can show a range keeping the comma delimiters
I have two columns of data showing prices, say $1,100 in one and $2,200 in another. I want to display this as a range in a report as "Your price is $1,100 - $2,200". I used this formula: "$" + $[Report Low Price]@row + " - $" + ($[Report High Price]@row which returns "$1100 - $2200", how can i have it include the comma…
-
Build a report that includes user input
I have a smartsheet with approx 30 parent rows and anywhere from 30-65 child rows per parent. I need to provide numerous individuals with reports for individual parent rows. Can a report be 'dynamic'? i.e., report requires input from user (preferrably by selecting from a dropdown) and then the report is generated. I…
-
Replacing an Employee in Smartsheet
Hi - if you hire a new employee to replace a former and want the 2nd to take the place of the 1st on all reports, how would you suggest the transition? Having the second employee sign in AS the first employee doesn't sound like the ideal situation. Thanks!
-
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…
