-
Source reports inaccessible from view only dashboard (sheet deleted error)
We have had an embedded dashboard with report widgets operational all year but am now receiving an error when attempting to open the source reports, but only from the view only dashboard. The error says "The sheet you were trying to open has been deleted". The reports still exist, are also published, and can be accessed…
-
What is the simplest way to have data from a form be pulled monthly into reports/dashboard
I have created a smartsheet form to log information on service intakes. I have then created sheet summaries and reports with a bunch of information (age, demographic, reason for call, type of service requested etc.). From this I created a dashboard showing key metrics and graphs of my data. My challenge is now I would like…
-
Merge 2 column names from separate sheets into one in a single report
Hi I want to create a single report that can be circulated on an email that pulls data from 2 separate sheets. In some cases I've been able to align the column headings, for example "Assigned To" is common across both sheets. However, in renaming that column, the resulting report no longer has an option to "Group" based on…
-
Allowing Editor Access to Report
Hi all, From what I can tell, sharing a report with someone and providing editor permissions does not actually allow that person to edit the report unless they have also been allowed editor permissions on the source sheet. Is there a way around this? Our work desperately relies on having "outsiders" able to edit reports…
-
Reports & New Columns
Hello - it is possible to add new columns to a report? Ie - add new blank columns? Looking at a strategy for planing where reports issue up to date information, and each team adds on their own relevant columns of information, driven from a Master planning document. Any experience with this, or do reports only generate info…
-
How can restrict editing of certain columns in report shared in WorkApps
We have started using WorkApps and we have a report that contains several columns that need to be viewed by the users for context/info and others that are required for them to edit. How can I protect the info only columns without locking the columns in the underlying sheet? There is no way to lock columns in reports is…
-
Remove Total Row in Report for Qualitative Metrics
I am using the summary function within a report, and I am using the "First" option of summarizing to bring the latest date to the summary field. There is no need for the "Total" column at the top of the report when summarizing a quantitative metric like picking the latest date in the column.
-
Formula Range no longer working
Hello - We have a report that is built to feed a dashboard. It has worked fine for close to a year. Today I logged in to complete our weekly report email, and all of my forumulas are showing the #INVALID REF error. When looking at the formula, the 'range' is still there, but it is no longer actually working, it does not…
-
Why is my report suddenly blank?
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
-
How to - Create report filtering on rows containing "Pending Open Update Request"
I have not found a method/solution to generate a report on the leftmost system columns and various statuses such as "Pending Open Update Requests" or has attachments, etc... Suggestions or How-to would be greatly appreciated!
