-
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…
-
Creating multiple graphs in a dashboard from one report or source sheet
I feel like I'm missing something - using only core applications, is there a way to create multiple charts in a dashboard for ongoing data (meaning every time a row is added I want the graph to be fluid to update accordingly from one report?) My understanding is if I'm selecting from the source sheet, its stagnant data and…
-
Why would a user that has edit-can share permissions on a report not be able to update filter?
I have given edit-can share and shared to report only permissions to a user of my report with the hopes they would be able to update the filters temporarily but they are unable to do so, when they hover over the is between date they get an x icon and cannot click it. I ran through the other permissions even up to admin…
-
WorkApp Comment: No Red dots showing for new added comments
We built a Workapp portal for our clients with edit access on the reports only (no sheet level access was given to any of our clients for security purposes). Now, I'd like to know why there's no red dots showing for new added comments when they're working at a report level housed inside the WorkApp. It's not helping our…