-
Emailing reports, except for when blank
I have a report pulling data from several sheets inside my workspace. Essentially it emails the report as an attachment every morning at 9am to my team and lists out open project needs. The question is there are some days when the report is blank (ie. no open project needs). Is it possible to: * not send an email if report…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Smartsheet Reporting
Hey all - I am attempting to build individual reports for users in our account. I am having a bit of an issue setting up the parameters of the report as I'm not too sure how to build it out. Is reporting only pulled from the column sections? If so, if I needed to pull reporting for an item on a row, how exactly could I…
-
Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?
-
Sum of hrs utilized per client
Hi Smarties, I created a time tracker with each column with drop down list for different clients. 1. I want to sum all the hours used per client and to appear in one cell per client, so I can link the cell to auto populate. I am familiar with step 2( cell linking). Can someone suggest how to run the report on a sheet with…
-
Send Row - Filter Save
I utilize the Send Row feature on a daily basis. The majority of the time, the columns I select from the "Customize" section are the exact same. It would be awesome if I could create a filter and have the ability to select it as opposed to manually selecting all of the columns every time. Thanks
-
maximum rows on a report
What's the max rows anybody has pulled into a report? Checking with Support, but curious in regards to functionality. The report will contain 65 columns. I've pulled over 5000, but I could have more for a new project we've rolled out. thanks, Tim
-
Year over year with Year-to-date calculation
Id like to create a formula to calculate year to date 2016 vs 2017 Example 2016 - I have total of monthly sales for all 12 months (jan-dec) 2017 I YTD have sales for Jan- march I want to look at Jan-march ytd 2016/vs 2017 % change year over year Thanks for any help! Tina
-
Question about tracking project budgets in Smartsheet
Hello all, I'm working on a task where I have multiple project budgets that we want to track in one sheet. I thought the best way to do this would be by using individual sheets and then running a report to include data from each sheet but our Finance department is asking for a way to do multiple jobs (projects) and…
-
Website migration project
Hello, I'm a new Smartsheet user, managing a large health care website redesign project. We have a large amount of content to move from an older CMS to a new one. We're also moving from a static to a dynamic site environment. Are there any users here who have used Smartsheet to manage and track a large content migration…