-
Summary Reporting from a Single Smartsheet
I have a single sheet used to log test defects. From this sheet I've created a summary section at the top for Open Items and Items by Status. I need to create another summary "Item Status by Sprint versus Production". I've tried Reports but this does not allow adding a summarization of the data (equivalent to an Excel…
-
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
-
Restore an "All" Where? functionality
It would be generous to call this an enhancement request. While I applaud the improvements to the Reporting (they are noticeable and appreciated), the inability to have an "ALL" for the Where? is a severe loss of functionality. I have many sheets and workspaces shared to me. They do not all exists at the time of Workspace…
-
Filters and sharing as an Viewer
We have a new user with with Admin privileges to their workspace. Their workspace has a sheet and a report. Their report includes data from their sheet, which they need to be able to edit from the report, but needs to also include some data, from another sheet in a workspace that we do not wish to share with the user. They…
-
Reporting over and under allocation?
Hi! Is there a way to create reports showing over (and under) allocation for assigned individuals? In resource views you can see the over allocations on a day by day basis, but I'd like to filter out only the over allocations and present it separetely since that is where actions needs to be taken. I looked for the "alert"…
-
Published Item Report
Hi all, Under user management I see the possbility to download a Published Item Report (see attachment). This looks an interesting report to me but when `I download it, it turns out to be empty. This surprises me because I administer a very active and relatively big Smartsheet implementation. Does anyone know why this…
-
Best practice of recording occurrences
Hello - apologies if this has been covered elsewhere, I've tried to search for the answer but can't find anything which may work for my purposes. Ultimately, it may not be achievable, but I thought I'd ask: I am creating a group of sheets for a team I work with, and they're dealing with recruitment of individuals (inwards…
-
Problem with "Current User" Report Data
I use a shared report for my team that populates based on "Current User." This report works fine for everyone except one person, to which it will not populate their data. Most of my sheets have a column called "Reporting Flags" to which i apply a verbal descriptor to pull certain rows into my report. So my report criteria…
-
Listing unique values in a column, and counting them (group and sum)
I have to import a list of orders and count how many times each unique product was ordered. So the orders may list the same ITEM hundreds of times (eg: Item123 x10 pieces). I want another list or sheet which displays a UNIQUE list of each item, and a COUNT of how many pieces of that item was ordered. As my order list…
-
Staff Holidays
Hi, Does anyone know a way of linking staff holidays with Smartsheet. I know how to set up public holidays but, want to see when individual employees holidays effect resource management? Many thanks Faye
