-
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.
-
Adding 30 or 60 days to a date based on another Cell Value
Greetings, I am trying to calculate either 30, or 60 days from a date, depending on the value of another cell. Example: Cell 1: Date Cell 2: $ Value of less than 50k or $ Value of $50k and up Cell 3: Date plus 30 or 60 days, depending on the value of Cell 2. Any ideas? Thanks!
-
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…
-
Process mapping
Does anyone use a process mapping tool such as Visio or TaskMap that can integrate well with Smartsheet?
-
Clone a widget to another sight?
I've got a nice set of KPI's pulled together on a 'demo' sight that I was reviewing with my team. Now that we're happy with the look and feel, I'd like to publish them to a different sight for a broader audience. I know there's a 'clone' button. I don't see an option to 'clone' a widget to another sight. Is the only option…
-
Scheduling an Update Reminder like an Alert
This is a test sheet (screenshot attached). I am trying to set up a method to where an Update Request is automatically emailed to the sales rep 3 days after the trigger date (Bid Date). This functionality is in the Alert Module, but in the Update Request you have to manually set a date each and every time; keep in mind I…
-
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…
-
Auto-Copy Formulas
I was having some problems with standard =this+that*something formula not copying down when I add a row. When I add an IF() statement to the formula, it seems to work. I noticed this, because all of the IF statements in other columns were working, so I thought I'd test the theory (add the IF()), and it worked. Anyone else…
-
Dynamic Allocation % / Resource Management
Monitoring RM (Resource Management) is pointless if the data is inaccurate! Current “Allocation %” is static (if RM is enabled) making RM data inaccurate! Please LIKE or bump if you agree that we deserve a truly SmartSheet w dynamic content! “Allocation %” should be able to accept a formula. Currently when you turn on RM…