-
Forecasted Project Progress
I would like to be able to create a graph that show forecasted percent complete over time (assuming activities are completed on time). This is daily and in the future. I assume this could be a report Something like: * Day 1 Projected Earned Value = 0% * Day 2 Projected Earned Value = 0% * Day 3 Projected Earned Value = 0%…
-
Can we get a new ETA for the report builder updates?
Hi Smartsheet Employees, This published dashboard by smartsheet shows that the Report features announced at Engage were supposed to be out in October. Is there a new ETA for these features? I am looking forward to them!
-
Sheet Summary Report From Smartsheet Into Appsheet
Greetings, I'm attempting to retrieve a Sheet Summary Report as a 'read-only' table in Appsheet. The error I'm receiving... The report you are attempting to open is a sheet summary report, which requires a query parameter of 'level=2' (or higher if available) to be specified in the API request. → Error 5623 in…
-
SUMIFS & FIND functionality with Summary Sheets
Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are "Cost Savings" or "Risk Management". I am also trying to create a formula for just…
-
Columns populated by formulat not showing up in report
Hi, I have replica sheets in different workspaces and I am trying to build a roll-up sheet. Cell linking requires too much manual intervention, so at present I am creating a report. In the report I need an additional column for 'Client' as the source sheets are client specific and do not have this column. I know that I can…
-
Report Enhancement from Engage 2020
I attended a session at Engage this year that showed new enhancements to Reports - the ability to sum columns and the ability to have parent row/groupings in reports. Does anyone know when that is coming out? I thought they said it would be out by the end of October, but I haven't seen the enhancements come through yet.…
-
Report tasks for two months
it is possible to make a report with sentences for the next two months and to automatically update the tasks for the next two months after these two months ??
-
RAG indicator options
Hi there community I have a portfolio of several hundred projects being monitored and reported via dashboards and reports in Smartsheet. We are currently using RAG indicators against schedule as follows: Red - Incomplete at reporting date or due date passed Amber - at risk Green - schedule within tolerances (+/- 10%…
-
Reporting like pivot or sumif. How to roll up values by name or category?
Is there a way to combine cell entries and give the total assigned to that category? Ex. Project Lead Cost savings John $100 Mary $500 Bob $400 John $200 Mary $75 Bob $60 REPORT = John Total = $300 Mary Total = $575 Bob Total = $460
-
is it possible to include a critical path in the report ?
is it possible to include a critical path in the report or in dashboard ? Unless there's some other way to get it out of the sheet into another sheet ?
