-
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?
-
How can I exclude a task(s) from my report if the predecessor for that task is not complete?
I have a dozen or so proejcts each with their own sheet. I've created a simple report that looks at each project and returns tasks that meet two criteria: 1. The task has not been marked complete 2. The task has a due date of 5 days or less. This report works fine, but it returns more data than I want to report on.…
-
Adding Parent Rows in reports
I am still learning my way around in SmartSheets and need some more help! I have created a report to show all "Past due" actions by owner. The report only lists children as we calculate Past Due status at this level - not at Parent level. Is there any way to include parent rows in this report, even if they don't have a…
-
Customize Metadata for Rollup Project Plan
Hi Community: I want to see if anyone would know the way how to customize the metadata for the rollup project plan. I would like to add more "columns" to allow filtering in the Portfolio Scorecard when my projects rolls up into the scorecard.
-
Row Level reminders (over allocation)
Does anybody have experience with a report showing over allocated persons in a project? What I mean is when person A works in project X on day 1,2,3 and 4. And the same person A is working in project Y on day 2 and 4. In this situation person A is over allocated on two days: day 2 and 4. How to get this nicely reported in…