-
Create a dynamic unique count metric sheet for a leaderboard
Hi All, I'm looking for a way to create a leaderboard from a sheet that tracks incoming submissions. We want to track the unique visitors and how many submissions each has created over a period of time, and I'm having zero luck. Any help would be appreciated!
-
Form Filler
It would be cool if instead of going from form to sheet it could go from sheet to form. I send out a lot of paperwork that if I could just populate with the info from certain columns, it would save me a lot of time or at least give me a fairly complete first draft of the paperwork I need to send out.
-
Formatting the Sheet Name Field within a Report
Hi! I would like to know if there is a way to format the Sheet Name column within a report. I would like the ability to middle align, and wrap text. Also, is there a way to remove row colors within a report without removing the colors from the actual Sheet? Thank You!
-
Report/Dashboard Question
Hi all, I am building reports and a dashboard for the support tickets my team receives. I want to create a report and chart to show the number of tickets our clients have submitted so far this year. Since we have well over a 100 clients, there are some clients that have only submitted 1 ticket this year. I'm trying to…
-
Reports: Joining multiple sheets by column names
Let's see if I can ask this correctly. I would like to have a report pull from 2 sheets. Sheet A: Resource (Drop down of people in department), Department Name, Title Sheet B: Project Plan (Possibly plans but lets stick to 1 sheet for now), with Assigned to , Status, etc Assume I make the Resource and Assigned to the same…
-
What is the best way to make a report that pulls from a very large sheet (14K+ lines)?
My source sheet is 14K+ lines and counting. Reports are limited to 2500 lines. Even when I have broken this data down by the quarter, this report is too large to even display all the data. What is the best way to support this?
-
Merged: Merge data from 2 sheets into 1 row
This discussion has been merged.
-
Printing Grouped Reports
I have a report that i have used the new grouping function on and i'm wanting to print it with the group headings but each time i print as pdf or export it only shows the standard cells, without the group headings, is this correct or is there something i'm missing?
-
Resource Management
Is there a way to create a master agile resource tracker and link it to every other project without having resource management?
-
Analyse three columns content and produce a representation of request priority
Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service booking summary Smartsheet we have a department ID of the requester in one column, a "date created" column, and a column that shows the user/form…