Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Reporting
Discussion List
-
First post 01/23/20,Last post 01/23/20Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. T…Using Smartsheet70Casey Sabatini -
First post 12/20/18,Last post 01/23/20I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…Formulas and Functions888CamCrichton
-
First post 01/15/20,Last post 01/22/20I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…Using Smartsheet163poweb048
-
First post 11/01/19,Last post 01/22/20I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I hav…Formulas and Functions337Brian Lynch
-
First post 01/20/20,Last post 01/22/20Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which proj…Formulas and Functions291soeirorenan
-
Alessandro Terranova 16 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 01/20/20,Last post 01/22/20Hi Community, I am in the process of creating a new Team workflow and I would really appreciate to discover how to easily import Trello Custom Fields into Smartsheet. I am aware of the Trello import procedure https://help.smartsheet.com/…Premium Apps and Integrations163Alessandro Terranova
-
Answered Julio Martinez Coronado 12 views 1 comment 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/21/20,Last post 01/22/20Hi, I'm using a template and it already allow me to flag a column when At Risk. I would like to count how many items I have flagged, but i'm not sure how. I've used =SUMIF({Sheet - Request Tracker with Form Range 1}, "Red") =C…Formulas and Functions121Julio Martinez Coronado
-
First post 01/25/19,Last post 01/21/20Hey team I have been using SmartSheets since day one and I continue using it. I have a question about a report that I have built. I have a report that I have built that pulls in all my projects plans title ROW 1 based on a where clause fo…Using Smartsheet395Kelly.Brady76386
-
Schedule VarianceAccepted AnswerAccepted Answer James Pflueger 21 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/17/20,Last post 01/21/20How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and t…Using Smartsheet215James Pflueger
-
First post 08/15/18,Last post 01/20/20I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!Using Smartsheet635Sgiovinazzo
-
Calculating average difference in dates between two columnsAccepted AnswerAccepted Answer Jeanice Truong 20 views 1 comment 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 01/17/20,Last post 01/20/20Hi I am trying to find the average time to complete a task without adding additional columns in my sheet. I would like to set it up in the sheet summary for easy reporting. In excel I would use the following formula. If a cell is blank th…Formulas and Functions201Jeanice Truong
-
First post 01/20/20,Last post 01/20/20I have a dashboard with 185 rows that I have added to a Dashboard. I don't want users to be able to click on it to view the full report, however Smartsheet seems to be limiting the number of rows that can be viewed via the Dashboard. Is t…Using Smartsheet71Tamara Kemper
-
First post 01/17/20,Last post 01/17/20Hello, I am having the exact same issue as Thor did in 2015 - https://community.smartsheet.com/discussion/385/losing-data-2 I sent out a current user view report to my project managers and when they all update their individual rows/report…Using Smartsheet200Gita Puvvada
-
Answered Shawn Borror 25 views 11 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/15/20,Last post 01/17/20I have a sheet of active projects. https://us.v-cdn.net/6031209/uploads/900/8XJWC47H1XNC.png I am trying to create a report filter on the Status column. However Status does not show up as a column either in row report or summary report. …Formulas and Functions2511Shawn Borror
-
First post 11/21/19,Last post 01/17/20While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not sc…Formulas and Functions658Paul Newcome -
First post 01/17/20,Last post 01/17/20I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?Using Smartsheet141rwholland -
First post 01/16/20,Last post 01/17/20Using the Employee Contact List - Template Set, I have created an employee contact list, with reports broken out by teams. When I add the reports to my dashboard, the grid lines show. Is it possible to remove the lines so that just the tex…Using Smartsheet202Pam Tadsen -
First post 09/19/19,Last post 01/17/20I have inherited PMO reposinsibility for a large program in Smartsheets. I am going through the process of linking the various schedules, finance/risk/issues registers and other sheets for about 15 projects, all of which link into sub-prog…Using Smartsheet305Kyle Furner
-
First post 10/29/18,Last post 01/17/20I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard. I am using the formula: =COUNTIF({Project L…Formulas and Functions14726BryanHeft -
First post 03/04/19,Last post 01/15/20Question 1: I'm pulling multiple reports together. I can't figure out how to issue any sort of GROUP BY clause. Please tell me how. Question 2: How do I pull Parent/Child meaningfully into a report? It doesn't seem to honor the relat…Using Smartsheet1317johnvilsack
-
First post 01/14/20,Last post 01/15/20Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sh…Using Smartsheet341Ian B
-
First post 01/15/20,Last post 01/15/20https://us.v-cdn.net/6031209/uploads/622/G1F72PTR3A1D.png Hello, Brand new to smartsheets. When I run a report, it grabs all the data from multiple sheets and the entire column of each sheet. This makes the report have 10+ rows for each sh…Using Smartsheet171David Playdon
-
First post 01/14/20,Last post 01/15/20Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sh…Using Smartsheet225Ian B
-
Slow updates on Formulas and Cell LinksAccepted AnswerAccepted Answer Allison Jones 32 views 6 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/08/20,Last post 01/11/20The last 24 hours have been a nightmare. I have been doing maintenance on some of our data sheets which have formulas and that link to roll up sheets. The cells are taking a long to to update -and in some cases haven't updated at all (i.e…Formulas and Functions326Allison Jones -
*NEW: Proofing using ReportsAccepted AnswerAccepted Answer amontemayor 43 views 20 comments 0 points Most recent by BrianBosché Using SmartsheetFirst post 10/01/19,Last post 01/10/20The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…Using Smartsheet4320amontemayor
-
First post 01/08/20,Last post 01/09/20I started my new position and am the new Admin for Smartsheet at my work. We converted the Workspace permissions for the owner to 'Owner' and me to 'Admin' and everyone else in our office to 'Editor - Can Share'. For some reason, nobody ca…Using Smartsheet251Tyler Gelbmann -
First post 05/13/18,Last post 01/09/20I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is w…Using Smartsheet8610philippejj0421 -
Accepted Answer Molly Morton 18 views 1 comment 0 points Most recent by lmarchisio Formulas and FunctionsFirst post 01/08/20,Last post 01/08/20I have a question about workspace and folders and reports. I have a company workspace with 3 folders in it; Active jobs, cancelled jobs and completed jobs. I have a report that pulls from the active jobs folders, but when I create a new sh…Formulas and Functions181Molly Morton
-
First post 01/06/20,Last post 01/07/20Hi! Working with one of the Smartsheet sprint planning templates and would like to be able to set different working patterns as two parties contributing to the sprint. i.e. Team 1 work Mon-Friday 8 hour day but Team 2 work everyday except …Formulas and Functions241Jessica Miller
-
First post 01/06/20,Last post 01/06/20I created an auto number column indicating a running matter number sequence for reference in my sheet and need to see it in various reports. I am not able to choose this column for the various reports. Why? Thank you.Using Smartsheet154Patricia W
