-
Can I make a person an Admin on a report but make them only as an Editor or View on base sheet?
I have created multiple reports from a base sheet but do I am wondering if one person can have different access levels to sheet and base sheet. I know they need access to the base sheet in order to view and edit information the report but I don't want them to have access to edit or share the base sheet.
-
Highlight Changes on Dashboard
Hello, I have created a Sheet with a form. I have taken the data from this Sheet into a Report, and then onto a Dashboard. I have turned on the "Highlight Changes" feature on both the Sheet and the Report. Anytime there is a new entry added to the Sheet through the form, it turns the data yellow. Unfortunately, this…
-
Include Attached Document in a report
Hey team I have been using SmartSheets since day one and I continue using it. I have a question about a report that I have built. I have a report that I have built that pulls in all my projects plans title ROW 1 based on a where clause for Example "Client Name - Project Schedule". In the actual ROW I have included the…
-
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 ??