-
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…
-
Super cool! Box integration and email upload
We use Box.com to store and collaborate on files with both internal and external colleagues. If you do too, here are two cool features you may not know about. 1) You can "attach" files stored on Box to your SmartSheet row. When a user clicks on the link to open the file, a new browser window opens inside of which Box opens…
-
Report missing row after additional row added in smartsheet
I have a smartsheet set up with all transactional sales for each region (including status, probability etc...) I also have a report written looking specifically at just one region. However, when a new line/row was inserted in the smartsheet the detail (new line) has not fed through to the report. The totals are correct…
