-
Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
Currently in a Project Sheet there is no way to automatically change a Date in the Finish column once the % Complete column changes to 100%. I am trying to have the schedule auto update the predecessors start and end date based on the date the ancestor task actually was completed. There is currently no way to automatically…
-
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…
-
Tabs!!
My team and I are having an absolute blast at Smartsheet ENGAGE! It is impressive and exciting to hear about all of the new features coming to smartsheet soon. If my team and I had a magic wand we would request tabs within sheets to allow for the ability to create a workbook (different/specific data per each tab). Thank…
-
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…
-
Automatically Add New Sheets to an Existing Report
Can new sheets be added to an existing report automatically? I am using Smartsheet as a project tracking tool. As I add new project schedules, I want those new schedules to feed an existing tasks assignment report. Can I do this?
-
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?…
