-
Template for tracking vehicle orders
Hello Smartsheet community, New to Smartsheet and hoping there is a timeplate that can help me with tracking vehicle orders. I have multiple orders open that I am waiting for the vehicles to be delivered. The orders vary from 1 to 75 vehicles and are of various make & models. I need to report on the overall status of all…
-
Displaying Pending and Submitted Update Requests through Reports or Dashboards
Hi, I am using smartsheet to manage the project work plan. Through the automation, I am sending update requests to task managers. I am worried that the update request emails be lost as some people regard them as spam emails. I thought if I can I show a list of pending and submitted update requests on either a report or…
-
Report / Compile Data on Multiple Sheets and select different date ranges
Two separate sheets: Employees: a sheet that contains a list of all employees Data: a sheet that contains data for some employees by quarter and by fiscal year The two sheets contain a common element: Contact name/employee email address I would like to see all employees with or without data for each quarter for one or more…
-
Text wrap in grouped report fields
Hello! First of all, I want to say that I love the new grouping function in the report builder. It's a game changer. I'm having trouble, though. In one report, the fields I'm grouping on are text fields, and they can get quite long. The underlying sheet has text wrap on for those fields, but that formatting does not carry…
-
Can I pull a report based on who has access to specific reports/dashboards for governance ?
In line with GDPR, I need to be able to pull monthly reporting on who access access to specific sheets. Is this possible?
-
Sheet summary - column formula
Hello, I am creating a smartsheet that aggregates the clubs that certain employees are in. That main component is done, and I am now using the sheet summary function now (mostly using COUNTIF) to link to a dashboard. However the number of entries on the sheet will change with new employees, which makes the sheet summary…
-
Hyperlinks in Reports
Hi, On the first day of each month, I send a report listing all documents published in the previous month. The report includes hyperlinks to each document's location. Before the recent Smartsheet changes to reports, I would email the report with the active links; however, the email no longer includes the links. How can I…
-
REPORT BUILDER REMOVING UNKNOWN SHEETS IF EDITED BY NUMEROUS ADMINS
Reports no longer show "unknown sheet" placeholders that the current user is not shared on If he/she edits the report builder on a Report that includes sheets he is not shared on it will remove those reports. Please bring back the placeholders so that the sheets added to the reports don't get deleted. We have multiple…
-
Creating Reports for just the current month
Is there a way to create a report that only displays this month. I know there is a way to show X days in the past, future, etc. I have a formula in my sheet that shows the month number to be able to find the current month number, but I don't see the ability to display only that data?
-
How do I show child AND PARENT rows in report?
I would like some help on how to show parent and child rows in a smartsheet report. See this loom recording for more context: https://www.loom.com/share/b55c7ed651994c2d8cfbbf1ed0d04665