-
Dynamic View for Calendar App
Similar to the way we can create Dynamic views of sheet data, it would be nice to create different user roles for a published calendar that is populated by each user groups permission settings. For example, I have one published calendar that shows events in multiple regions, but I would like to continue using one published…
-
Best practices for adding instructions to a sheet?
Hello! What works well for adding "How To" instructions for a sheet? Rather than create a separate document for a User Manual, I'd like to embed the instructions right into the sheet. I see two main options: * Using the comment functionality in a row. * Adding a text column. In a perfect world, I'd create as much…
-
Project Intake Sheet and Project Metadata - Not Updating Yellow columns Automatically
I'm trying to figure out how the yellow columns with Start Date, End Date, Dashboard Link, Schedule at Risk and Project Status. Everything is updating except for the Start Date and End Date. Those are staying at the default of 12/19/19 and 2/11/20. Where are those supposed to be pulling from. I followed the instructions…
-
Zero Formula
Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much.
-
Moving children rows under a different parent row
Is there a way to set up a formula that will move project status "completed" from under one parent row to another parent row named "Completed project" once the project status has been selected as completed?
-
Symbol column - Empty, Quarter, Half, 3/4 and Whole - Update Color
Hello, When doing a project plan, I'd like the ability to update how this symbol color shows up based on what they choose for their milestone completion progress in this column. Right now it shows up as light gray however that is usually the color of the header rows and it is hard to see. It would be nice to have the…
-
Best template sets for use with Resource Management?
I will be getting access to Resource Management soon, but I need to begin the process of moving all of my company's project plans into Smartsheet before I will have access. Are there certain template sets that are designed to work with Resource Management? I would hate to get all of the projects moved and then find out…
-
Is there a size limitation for attachment files?
Is there a size limitation for attachment files? AND is there an overall limit for all attachments added to a Smartsheet? Thanks for your help! JanP
-
PM trying to see overdue tasks across all projects ONLY for projects I am a PM of
Hi all, I am a project manager and there are 5 project managers in my organization. I want to be able to pull a portfolio level report to show all the overdue tasks that I am a project manager of. I have control centre and I also bring in PM as a profile data into my project plan. What is the best way to achieve this?…
-
Representing Multiple Phases on a Single Gantt Chart Row
Hello Smartsheet community, I’m working on a project where I need to visually represent different phases on the same row of a Gantt chart. For example, I have a project that runs in three phases: Phase 1: January to March (Yellow) Phase 2: March to June (Green) Phase 3: June to July (Red) Is there any native solution or…