-
Report Gantt formatting is not showing in the dashboard
Hey All, First time post. I looked through some keyword searches for my problem, but didn't find this specific issue. I am rolling up all my projects into a high level filtered report and formatting the Gantt for my directors using the following settings: Everything looks great: However, when I pull this specific report to…
-
Report Filter on API generated Field
For several months we have been running an API from FUB that populates 8 different sheets. From there we run a report to filter the information via specific columns. Last week the reports stopped functioning and names seem to have changed. See photos, "Created" no longer exists. We'd like to resolve this by filtering on…
-
Reports: Providing $ totals for only new entries
Hello- I've developed a sheet that tracks new registrations, with info like name, program, registration cost, revenue totals, etc. I want to create a weekly report that includes any new entries added to the sheet since the last report, but also to include the total financial sum of those new entries on the sheet. If I…
-
Make reports un-editable?
Hello! How may I ensure a report cannot be edited? I recently created a new report and my viewer deleted rows in the report. This deleted not only the rows from the report, but from the underlying dataset as well. I must now start over from scratch. Previously reports were not editable, or so I thought. How can I prevent a…
-
Report Creation
Greetings, I am creating a report to check the incoming date of certain items for multiple projects. While creating it, only the parent row is getting imported to the report. Is it possible to incorporate the children rows as well ? The structure of my rows in the original sheets are as follows: Shipment of X for a…
-
Open Report Calendar View with Current Month
I can open a report in calendar view, but it opens on the first date in the report, and I want the ability to go forward or backward through the calendar. Is it possible to open and show the current month by default?
-
Is it possible to edit a report from a dashboard?
Hi. We are creating a Smartsheet dashboard for our incoming projects. Each project manager will need to make comments to their respective projects. Is is possible, if we add the project report to our dashboard, that a PM can edit the report from the dashboard and have it save the edits? Thanks, Shawn
-
Trouble using countifs referencing another sheet and adding either "NOT" or an "OR"
I am trying to write something that will do multiple countifs and either include a range of ORs or allow me to exclude rows that have a particular response in a given column. =COUNTIFS({NEOP Tracking Range 2}, [Column5]12, {NEOP Tracking Range 4}, [Column5]@row) This works great. Now I need to only see employees that have…
-
Data entry into a report
Hello, I would like to have users enter data into a report, and not the underlying sheet or sheets. I know you can edit data in a report, but you cannot enter new data from the report view. Is this possible? Or are there creative ways to do this? I was thinking of creating a dashboard with the report, and then an entry…
-
Maintaining Sheet Parent-Child Relationships on Reports?
Is there a way to maintain the Parent-Child task relationships from a sheet on a report? I am trying to create a Gantt view to use as a timeline on a report so that users do not have to access the actual project plan to see this update, and to focus the users on specific information. Unfortunately, the Parent-Child…