-
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…
-
Smartsheet merge for google doc
Hi all, One of my departments is using merge for google doc this works fine. But I wanted to try to merge a report but this is not possible. I think it is nessesary to present a report in a more document form. Ofcourse it is possible to do it from the original sheet but you need to scroll allot if you have 100 rows.
-
Question about creating a pricing sheet with multiple linked sheets
Hello, New to SmartSheet and have only been through the basic training video. I understand this product is super powerful and can do just about anything related to spreadsheets. I just wanted to reach out to the community to see if what I was looking to accomplish is something the group feels is obtainable before I keep…
-
When will Smartsheet be able to produce comprehensive reports and link Gants charts into WBS's?
I'm an advocate of the intuitiveness of smartsheet and use this programme over other PM software for gant chart use. I find it is more user friendly, easier for collaborative use and the fact I can use this on all platforms. My question is, why does smartsheet not have the ability to produce WBS and comprehensive reports…
-
Can I build a resource pool to choose from for multiple projects?
Is there a way to build a data base of human resources (assigned to) that I could choose from when working within multiple projects? Is there a way to indicated allocation % of that resource so I can understand if certain resources are being over-allocated or under-allocated?