-
Calendar view of all Projects, the resources assigned to the projects, and their associated allocati
We are looking for a way in SmartSheet to present all projects (ideally, can be sorted/filtered by workspace) and the resources assigned to each project, and the associated allocation in a calendar view. I have created a quick mock up of the presentation attached. No capability to do Reports in the required Calendar view.
-
Slow Response Time
Hi all, Is anyone else struggling with slow response times from Smartsheet. I have around 40 sheets that i work on, and 1 tab open. Even simple tasks like moving the mouse and clicking on a cell or an option is taking around 30 seconds to complete the action. I have tried this in empty sheets and still finding the issue so…
-
Missing Column Criteria from Report Builder
Hi, I have been working on a report builder for a number of sheets from varying projects to show specific items. Understanding that I need to have consistent column names across all sheets, I have gone through the trouble of formatting them all. My issue now is that when I go to the report builder and I want to add more…
-
Report Builder - Pull projects completed one year ago (month)
I would like to auto-run a report of projects completed over the course of a month one year prior. (i.e., the report would tell me on August 15, 2017 what projects were completed between August 1 and August 31 last year). I plugged in report builder that the column I want it to filter by (Actual Completion Date) should be…
-
Sum values from a report
Hello, I have a log sheet that records a project name, resource and hours, with many rows of entries. I would simply like to create a report that sums all hours by project. I don't see how this works in the report function, but it seems like it should be doable. Any help would be appreciated. Nick
-
Consolidated SmartSheet
Hi all, I am pretty new to Smartsheet and in need of some help. We are using smartsheet for an upcoming budget task. I have created over 50 different sheets. In each sheet there is a column with checkboxes. I want to have a user check the box when the specific task is completed. My question is, is there a way to create a…
-
Shared reports are blank
Hello, After performing a search I ran across many others users running into shared reports showing up as blank pages. I tried the solution I ran across and assured that the user also had access to the sheet the report was made from. And still I am seeing a blank report. Was this ever corrected in early/mid 2016? I am…
-
Using Zapier to Move Attachments and Comments
Is there any way to have Zapier move an entire Sheet's contents? I am trying to automatically move selected contents of a row that contains confidential information to another sheet that can be viewed by a user who I don't want to access that confidential information. But I also want them to be able to comment on the…
-
Using Reports to Isolate User Access
I need to manage information pertaining to a client (single row per client) that contains three different types of information used by three different users. The sheet has formula that I want to continue down the sheet automatically. Because we are using webforms to register new client information, every time a user goes…
-
Creating user Dashboards as Sights - filtering
I am creating sights for team members on my projects so that they can see their assigned tasks all in one place - no doubt a common use for Sights. Anyway, when I link multiple sheets into a report and expose the sheet name, when the user clicks on that link, they are taken to the sheet and not the row. Is there any way to…