-
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…
-
Why can't I choose the auto number column for my report?
I 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.
-
How to create reports in a Legacy Individual Plan ( Pre February 1st 2019)
Hello everyone, I tried to contact support but I got no answer, so I'll try to ask for help here: I'm trying to create reports. On the "plans & prices" page it appears that with an "individual plan" there is the possibility of creating up to 5 reports, but when I do try the option is greyed out. By doing a little research…
-
Reporting Question: create a report that aggregates Column information
Hi, I am trying to create a report that aggregates Column information based on a Condition. For example I have the following columns: -Track -Track Status -Days I would like to know a roll-up of the status by Track and then use days as a filter criteria. So if the days are 30, it would show status for just those that are…
-
Why am I only seeing system columns in Report Builder?
Hi, I am having an issue showing columns other than System Columns in the report builder. As you can see from the attached I have my sheet selected. What am I missing? I tried saving and going back in, but this did not fix this situation. Thanks, Paul
