-
Report not pulling source sheets for shared users?
I have a shared report that is not showing any data for someone I have shared it with. The 4 "Source Sheets" are not pulling and as a viewer, she cannot add or remove sources. The report shows fine on my end (as the owner) but she was shared as a viewer and cannot get the data. Others shared to this report as viewers are…
-
Plan Usage user downloaded report
The user report generated in Plan Usage pulls in the users Job Category as the Department, instead of the Department listed on each user profile. Is there a way to customize the report, or another report somewhere that pulls in the correct department for each user?
-
Customize Calendar Display Column: select more than just the Primary Column
Restricting the Calendar to only display the Primary column is a problem. We need to be able to configure the Calendar View to show whatever column is needed. This is particularly useful if you are creating multiple calendar reports from one sheet with different titles needed.
-
Dynamic scope report in Control Center not pulling the files
Dear All, I am struggling to figure out why a dynami report I set up in Control Center doesnt pull in the files. It is stubborn to keep only 1 file, instead of the 30 I think it should. Is there a setting in CC that I missed? I followed the instructions. First I created a report in a designated workspace, added it to the…
-
How to build a consolidated calendar from many other sheets.
Hi I am currently developing departmental marketing calendars with a team for different portfolio's. For example we have events, B2B, B2C, Digital. Each calendar has past and active/upcoming items. My ultimate goal is to get all the data from the calendars and pull it onto a consolidated calendar for the whole department.…
-
Summarize Not An Option on Report
I'm working on a complex report, but the summarize option has gone away for a column that was previously working. Anyone have any idea on how to get this to return? This was previously showing, but I tweaked the formula which made this option go away. I've tried to remove the column and add again, but that hasn't worked.…
-
Month over Month Variance w/ live data help.
Hi SS Community, I am trying to create Month over Month varience report for my project management work flow. I currently have a Smart Sheet and Sales Force integration that updates my data live 2 ways, and that's where my problem begins. Below is a screenshot of Project Status dashboard graph as of 10/28/24 . I'd like to…
-
Merged: Report Needed -> Users & Groups
This discussion has been merged.
-
Report Filter by date
I need to create a report for past due items. As such, I need to compare a due date to the current date. How do I do this in a report? I don't want to set the date to today every time as I want an automated report. I tried putting in the compare date to the sheet I am reporting off of but there is no option to compare two…