-
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…
-
Slow updates on Formulas and Cell Links
The 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. I can see in the cell history when the last update "cell-link" update was and it was…
-
'Editor - Can Share' users cannot run reports?
I 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 can use the Report Builder to run a report unless I share that sheet with them and give…
-
Workspace - adding a new sheet to a folder - report is not picking up that new sheet
I 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 sheet that report does not automatically pull in that new sheet. My question is, what…
-
Can 'Working Days' settings vary per assignee in sprint planning?
Hi! 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 Friday. Setting the working days in Smartsheet for either Team means that the…