-
Feature Request: Toggle on/off a Report Builder search parameter
What I would like to be able to do is toggle on/off search parameters in the Report Builder for a given report. I have a report which I use daily. There is a search parameter I which I want to be able to activate and de-active to get a certain view of the report. For example, I embed a keyword/tag in the Primary column…
-
Sorting heirarchy numbers (1.1, 1.1.1, 1.2) in reports
Hi everyone, I am using reports to merge 20 to 30 sheets and sorting them on multiple and different heirarchy columns (containing numbers such as 1.1, 1.1.1, 1.2). This doesn't really work out of the box because the report sort is apparently just a standard natural sort and doesn't recognize this notation. I wasn't able to…
-
Owner Task Counting and Reporting
How would I create a formula to calculate tasks complete (last 30,60,90 days), open, past due by owner similar to this screen shot which comes from the Webinar - "Manage and Track Tickets with Custom App".
-
Create report based on a conditional format in sheet
We are trying to build a report that looks at the format of a cell in the main sheet. We are using the conditional formatting option to set a specific cell's format based on the combination of various other fields in that row. Now that the sheet is correct, we are going to the report builder to create a report that looks…
-
Report sections
Is there any way to create sections within reports that have their own column headings? I want to combine two reports with mostly different fields into a single report to send to management. Using the standard report layout, I end up with a bunch of blank cells and long narrow columns. If there is no workaround for this, I…
-
Star Ratings/ Symbols - changing amount?
Hi, I have a sheet where we want to monitor the value of a project simply with a 1 to 3 star rating, but the only star symbols available are either an on/off, 1 star symbol, or a 0-5 star rating. Is there any way of reducing the mount of stars to simply 1-3, or is there a formula (similar to the RYG ball) to show this? I…
-
What is the best way to consolidate data from multiple sheets to a single row
Hi, hope someone can help me. I am using smartshheet as an internal onboarding process. This process requires me to collect data from 2 webforms entry for same client that autofills 2 different smartsheets, one smartsheet with about 20 colums and other with about 35 columns, OR a single webform to a single master…
-
Feature Request: Row Summary Documents
Our business utilizes Smartsheet in so many ways. One feature that continually wish Smartsheet had is what I call a "Row Summary Document". This feature would essentially mimic the Form builder already contained in Smartsheet, however it would be in reverse. The form would actually be populated based on an already…
-
Lock column in report
How can I lock a column in a report? When I right-click a column in a report, I don't see the "Lock column" option.
-
Wrong sorting order with numbers smaller than 1
Hi there, we are using a column "Estimated work in days" with a DropDownList with the values: 0,25 0,5 1 2 5 10 n.a. t.b.d. Please consider "," here in Germany is the decimal separator. Sorting the rows in a sheet leads to an order were rows having 0,25 or 0,5 are listed below (or on top) of t.b.d. In reports the sorting…
