-
Countifs project status is neither complete nor cancelled
I'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 have other working formulas, but this is out of my expertise. Here's what I have so far.…
-
Smartsheet and Trello - Custom Fields import to Smartsheet
Hi 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/articles/504553-import-files-to-create-new-sheets, which is working correctly, however,…
-
Calculating average difference in dates between two columns
Hi 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 the row will not be calculated as part of the average.…
-
Max number of rows on a dashboard
I 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 there a way to increase the number of rows viewable on the dashboard? If not, is there…
-
Attempting to add a column to report that is under Summary task
I have a sheet of active projects. 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. The first task is a summary task and all other tasks below are children.
-
I don't want grid lines to display on my dashboard. Can these be removed (or made not to show)?
Using 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 text shows? Thank you! Pam
-
Trying to count multiple people in a cell
I 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 List Range 3}, Assigned1) Where Project List Range 3 is the Column in my master sheet…
-
How can I format a sheet or report to create a customer facing inspection signoff
Hi, 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 sheet showing all measures that were inspected where they write down the quantity of…
-
Reports-Data from single cell/row from multiple sheets
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 sheet, when I want one row from each specific sheet . Is there a way to define what row I want to report? I would like to be able to run a report…
-
Is it possible to generate a client sign off for an inspection in the field using a tablet?
Hi, 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 sheet showing all measures that were inspected where they write down the quantity of…