-
Is it possible to use Group information in Smartsheet Reports?
Hi Is it possible to access the Group that a resource in the 'Assigned To' column is a member of, in Smartsheet Reports, eg like doing a VLOOKUP on the resource name? Many thanks. Nigel
-
Reports using HOURS past Creation Date/Time Criteria
Hello friends, I need to be able to create a REPORT where the only rows that appear are those that are equal to or greater than 3 hours past the Creation Date/Time. Is this possible?
-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
No matching rows found when I try to create a report
Yesterday I asked, and David Tutwiler answered, how to locate the "create reports" section. This was helpful and I created a report. When I press "run" it says "no rows found." A coworker said I don't have a license and that is why? Please let me know. I can do many other things I was told individuals with licenses can't.
-
Looking for suggestions - master formula errors report
Hi all, looking for suggestions based on others' experiences. We have a series of dashboards and their respective back end sheets that occasionally throw formula errors for various reasons. I'm hoping I can leach some ideas from the Community on creating a master report/notification that informs us when any error occurs.…
-
Help setting up Inventory report with possible graphs
Hello, We are using Smartsheet as a temporary monthly server inventory reconciliation. There are about 10 columns/headers to print, 700 lines. I haven't used Smartsheet before so I'm finding it difficult to locate how to set up a report. Its the first month of showing all the inventory as such. The lines are machine name,…
-
Report which pulls from multiple tables used to validate data coming into a process
i have a scenario where the business would like to validate data coming into a process and check to see if this data set has already been visited (decision made on how to handle it), it it was decided upon, then the record would adopt certain fields and the record would move into the tables. If it was not visited before…
-
How can I stop a "send as attachment" email notification on a deleted report?
I had set up a weekly schedule to send a report as an attachment for a team member. This team member has now left the team, and I deleted this report as it was only relevant to them. I assumed that would end the weekly notification emails being sent to them, or I didn't really give it a second thought since that email…
-
Referencing the last comment to update a column
Hi Community, I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet. I'd still like to use the comments thread so other Project Stakeholders can reference the communication for each…
-
Filter for Current User - View on Dashboard not working as planned
Hello Smartsheet people, I have a report that is pulling in all open tickets from a single source sheet, and I want the report displayed on a dashboard. I want this specific report to only show the tickets assigned to the current viewer of the dashboard. The 'has current user' filter is on, and the column type is a contact…