-
Manually Adding to Reports
I'm looking for a way to pull information from other sheets, while also being allowed to manually add data. The reason I'm doing this is to allow for staff to go to one place where we can share individuals goals, tasks and progress. Is there a way to do this? I have tried formulas, but I do not believe it updates when that…
-
Report Blank
Hi, I'm trying to create a report based on a sheet I'm an admin on, but it's coming up blank. I build the report based on that sheet, so all the column match. If I select a different sheet it works & shows all the information. I tried deleting it & starting over, still seeing nothing. Not sure what's going on. Help? Thanks!
-
Reports Malfunction
Hi, Are reports malfunctioning with anyone else today? I thought I was doing something wrong until I read the past community posts suggesting prior issues with reports. /-RI
-
Report Builder - What section
Hi, I'm trying to number actions on my list as 1.1, 1.2 etc, all relating to a section 1 in my smartsheet. I also have a handful of actions that I need to number as 1.6a and 1.6b etc. When creating the Report Builder however, the 'What' section doesn't seem to handle the letter, only the number, therefore any rows that…
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Using the Project Management Dashboard Template
Hi all, I'm a newbie to Smartsheet and am evaluating its use within our organization and so far I like what I see. As a PM one of my tasks to do project status reporting and so I had a look at the Project Management Dashboard Template, this is a good basis for what I want to do. However, if I update the task dates in the…
-
Pie Charts and 2 rows of data - Possible Bug w/workarond
Just submitted this to Smartsheet, thought I would share with the community to see if it was indeed a bug, or if anyone else has experienced the same? Bug: I have a report with two lines of data showing... When reflecting that data on a dashboard, I am unable to select a pie chart when there are only two lines of data from…
-
CORS in Ionic and third party api(Smartsheet)
I am trying to get data from smartsheet API. When I use postman and nodejs in separate server code, it works. But if I use the API inside the Ionic with HttpClient (@angular/http) it gives CORS issue with run in browser. Failed to load https://api.smartsheet.com/2.0/sheets/1235941564208899972: Response to preflight request…
-
Showing completed items 8 days after completed
Hello, I am trying to make my report so that if an item's status was changed to complete in the last 8 days that it would stay in the report so that our client can see it was completed within the last week. I've figured out a way to do it in the sheet but not in the report. I there a way to do it in reports?