-
Users sees sheet owners report information and not theirs when using "current user" as filter.
I have created a sheet called "absence request" where employees enter their absence from the office. In the sheet there is a contact list field that populates the "created by" information. This sheet contains an approval workflow. On this sheet I generated a report to show all approved and another showing all pending…
-
Report embedded on a dashboard
I add several reports on dashboards and I would like the collapsed view of the group I set up to be the default view on the dashboard. Is this possible? Thanks, Becky
-
Can I used conditional formatting to high duplicates in reports?
We have several grant programs within our organization and I am working on funneling all the form submissions from each into a main report. I would like that report to identify duplicate submissions so I can consolidate and make sure candidates aren't overwhelmed by having too many cases open. Can I use the conditional…
-
Report shows blank to Commenter / Editor - can share
Hello. I have a couple of reports sitting in a Workspace where colleagues have Commenter access to the Workspace. I additionally granted Editor - can share access to the reports themselves, but neither staff member can see the contents of the reports (reports are blank for them). They saw contents prior to yesterday when…
-
Expand/Collapse Groupings in Report
Hello, Is it correct that the expand/collapse button in grouped reports only manages collapsing and expanding the last grouping? I have a report that has three groupings and I would like it fully collapsed when opened but it appears that the collapse setting is only applying to the lowest grouping.
-
How do I make a complaint to Smartsheet
Yet again things have changed in smartsheet world with no notification. Reports, I don't develop or use them often but they are now becoming useless. only a licenced user can change a report filter - so if you are reporting on a date range only a licenced user can change this. Meaning I have to go through every month to…
-
Can I pull columns in different Sheets in one report as long as Primary Column is the same?
Dear All: I tried the Community and I came up with nothing. Can I pull different columns in different Sheets in one report as long as the Primary Column is the same? The columns I need exist in different Sheets, not all Sheets have all the columns. However, the Primary Column is the same (“Interpreter Name” as Text/Number,…
-
Reports on Automations and Published Assets
From an Admin perspective, has anyone found a way to report on these concepts (globally, even if you are not the admin/owner of the sheets) Recipients of Automation alerts who are outside of your domain Lists of automations that will fail unless something is rectified Master list of Automations, their type / outcome,…
-
Report not pulling formatting from source sheets
I can't seem to figure out why the formatting in place on the source sheets we are using are NOT pulling into some of the reports we've created. Works on some but not others. Everything I'm reading says that formatting in a report is based on the formatting in the source sheet. I've looked at other reports that are working…
-
How to add an Image into a cell in a Report
We have a single sheet broken into many reports that different users use during a process of development of a product. The sheet holds all the columns and is the single source of truth while the reports give snap shots of each step and only shows columns relevant to that step/user. My question: You can copy/paste an image…