-
Reports not populating correctly
Hi! I was hoping someone could help me. I have a report that I have been using for about a year now. It pulls all of the tasks and due dates from my sheets (43 sheets total) into one report that I can sort and filter by date and who it is assigned to. Recently, I have noticed that not all of my tasks are being populated on…
-
Format cells in sheets and reports that have an update request
Has anybody found a way to highlight (change cell color or format) a cell or row in a sheet, once an update request has been manually requested by a user? Additionally how can the same highlight be extended to reports built off of that sheet? We have users manually requesting updates to a single column in a report, but as…
-
Building Metrics based off report data
Is there any way (I do not think there is) to add metrics on a dashboard based on results in reports? OR To show the summary view in a report on dashboards. If not I can add a feature request.
-
Reports based off Folder
We have an "Active Projects" folder. Is there not a way to auto add a sheet to a report that is placed in that folder? Currently, I have to go to the reports, select the folder to ensure it's all added. Is there any way to do this?
-
Reports not refreshing
i have a number of reports which have a due date column. the reports are looking at those with a due date in the past or today. They had been working fine but for some reason now if i update the due date in the row and refresh the report nothing changes. i have to log out of smart sheet for the change to be picked up?
-
Calendar view on dashboard
Is there a way to set the default view of a sheet/report on a dashboard to calendar? (I don't have the Calendar App.)
-
Report Grouping
I have created a report, but noticed not all the columns I select for the report are available to be grouped by. I have this one column that I would like to be able to group by but it's not available to select. Can you tell me if there are some constraints around the types of fields that can be grouped by? BTW, I love this…
-
Show the children of a row in a report
Dear all, I have a sheet with a hierarchy of rows (parents / children / grand children), I have a report that selects parent rows, I would like to show the children / grand children of the selected parent rows in my report even though the children / grand children do not meet the selection criteria. Is this possible?…
-
Unnecessary scroll bar on published view only report
Hi, I am working on a Dashboard for my team and when using a widget to display a report that is published/view only, there are way too many unneeded scroll bars. It is set up size-wise so that there should be no scroll bars, however there are two vertical and one horizontal. Is there any way to get rid of these? Thanks!
-
Weekly requests Received & Sent
Hello! I am trying trying to come up with a formula for a Sheet Summary field that can output the number of received requests and number of sent requests over the course of the current week for each member of my team. I have a [Received Date] Column and a [Date Sent] Column where the dates are inputted but I just need the…