Project Management

Discussion List

  • Percent Formatting applied, but entry of 100 is shown as 10,000%
    In Using Smartsheet
    I have the entire column formatted as a percent, but when I enter 100, it shows as 10,000%, or when I enter 1 it shows 100%.  Would like for the number entered to show that percent. 
    1453 13
    1.5K views 13 comments Most recent by C. Peter Datz Using Smartsheet
  • SUM of Only Parents in Budget Sheet
    In Formulas and Functions
    Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Sameer Karkhanis Formulas and Functions
  • How to add an Image into a cell in a Report
    In Using Smartsheet
    We have a single sheet broken into many reports that different users use during a process of development of a product. The sheet holds all the columns and is the single source of truth while the reports give snap shots of each step and onl…
    23 3
    Accepted Answer 23 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Effort Vs Duration
    In Using Smartsheet
    Hi I am new to smartsheet and wondered if you could help. I would like to create a project plan which shows the effort required vs the duration. for example: a task may take 2 days to complete however they can complete this anytime with…
    Em Profile Photo Em
    1810 12
    1.8K views 12 comments Most recent by Ted Hassanein Using Smartsheet
  • Is there a way to pre-populate past survey responses by user?
    In Formulas and Functions
    I have a feedback survey(form) that users fill out a few times a week and I was wondering if there is a way to have their responses pre-load from the last time they answered. For example, say they fill out the survey three times a week and…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • No Predecessor but Date Cell won't change
    In Using Smartsheet
    I am working on a schedule and have a row with no predecessor, however the "start date" won't let me manually change it. It keeps auto-correcting back to the same date that has been in it from the beginning.   Any thoughts?
    4115 13
    4.1K views 13 comments Most recent by RJosephWilson Using Smartsheet
  • RTF in Dashboard Widget
    In Using Smartsheet
    I downloaded an example dashboard which tracked multiple projects.  Looked good and decided to build my dashboard to match example.  Example dashboard has a Rich Text Widget which has multiple formats within.  However when I try to use the…
    445 11
    445 views 11 comments Most recent by Andrew Bunn Using Smartsheet
  • IF Statements when a score / number is between two values
    In Using Smartsheet
    Hi there! I'm working on a dashboard which will show the overall "health" of a program. I'd like the health score I've already devised to display on a sheet as "Red" "Yellow" or "Green" depending on …
    3253 27
    3.3K views 27 comments Most recent by Paul Newcome Using Smartsheet
  • How to view your roadmap in Smartsheet
    In Using Smartsheet
    Hi All, I have just uploaded the Agile product roadmap template from smartsheet to create my roadmap in smartsheet account. After creation, I have not been able to visualise the end product as a roadmap (see image attached). Do i need to …
    861 11
    861 views 11 comments Most recent by SW66 Using Smartsheet