-
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…
-
Document Builder
We have a fillable pdf that we use for daily reporting, tied to a sheet via document builder mapping, and are testing it's use for our purposes. Once we're satisfied with how we have it built, is it possible to keep that fillable pdf attached to our daily report "template" sheet when we save it as new into project specific…