Project Management

Discussion List

  • RAG status formula using TODAY and end date
    In Formulas and Functions
    Hey smartsheet community, any help fixing this RAG status formula? I am trying to automatically show RYGG balls dependant on the end date and today's date. With the exception of cancelled and complete tasks; any task with the end date TOD…
    Answered - Pending Review
    413 6
    Answered - Pending Review 413 views 6 comments Most recent by L_123 Formulas and Functions
  • Stacked Bar Chart with Percentages
    In Formulas and Functions
    Hi There! I am trying to track and present progress on key milestones made by multiple countries to share with our donor. I want to be able to show the average percentage completed overall for the milestone, but comprised of that show the …
    Accepted
    301 21
    Answered ✓ 301 views 21 comments Most recent by Paul Newcome Formulas and Functions
  • Combined Calendar Report - Can I Automate Labels?
    In Using Smartsheet
    Hello! I am a Project Manager trying to redesign how my company uses Smartsheet internally, and I'm hoping to use Smartsheet to replace several other tools we currently use. My current goal is to create a Dashboard where an individual on …
    Answered - Pending Review
    93 4
    Answered - Pending Review 93 views 4 comments Most recent by Ethan Moses Using Smartsheet
  • Project Health Formula to Auto Populate a Symbol
    In Formulas and Functions
    Hi I have a formula that flags the health of each row (task) via a RAG status. Green is healthy, Amber is at risk or in progress and Red is a failure. This is set up to work off the start date and % complete. However, it just isn't right. …
    Answered - Pending Review
    186 6
    Answered - Pending Review 186 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Form selection of dropdown list inserts choice with hyperlink
    In Formulas and Functions
    We have a project management Smartsheet where we have about 3 different "standard work" choices - these are selections where the requirements are the same each time. This list may grow later. On our request form, I'd like the use…
    Accepted
    162 6
    Answered ✓ 162 views 6 comments Most recent by Genevieve P. Formulas and Functions
  • Using a master sheet to change multiple sheets
    In Using Smartsheet
    Currently, I have a project template that I use for opening a new location. Our company is typically working on 5 or more location opening projects at a time. When changes need to be made to the basic structure of the project plan (i.e. de…
    Accepted
    264 3
    Answered ✓ 264 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Update Parent Row based on Child status
    In Formulas and Functions
    Hi! I want the Parent row to automatically change with the most recent Child Row status. I currently do this manually so I have to update the status in 2 different rows. Right now I have this: =IF(COUNTIFS(CHILDREN(), "Open") &…
    Answered - Pending Review
    413 4
    Answered - Pending Review 413 views 4 comments Most recent by Kelly Moore Formulas and Functions
  • Send as attachment - PDF + Excel ?
    In Formulas and Functions
    Hi Guys Another day another Smartsheet query - is it possible when sending a report as a scheduled attachment to send both the PDF & the Excel in the same email? Or is there a workaround in order to do so? Thanks! :)
    Accepted
    37 1
    Answered ✓ 37 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • End Date is auto-filled, how to stop?
    In Formulas and Functions
    Hi All, I have created a sheet for my team and outside of normal columns, we have an extra "Target End Date" to track if we meet target or not. Please see picture. However, the Actual End Date is auto-filled every time I enter …
    Accepted
    57 1
    Answered ✓ 57 views 1 comment Most recent by Antonio Figueroa Formulas and Functions