Project Management

Discussion List

  • 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
    82 6
    Accepted Answer 82 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
    156 3
    Accepted Answer 156 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
    218 4
    Answered - Pending Review 218 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
    34 1
    Accepted Answer 34 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
    26 1
    Accepted Answer 26 views 1 comment Most recent by Antonio Figueroa Formulas and Functions
  • Formula for RYG for Project Schedule Status
    In Formulas and Functions
    We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the critical path the project should be in …
    Answered - Pending Review
    36 1
    Answered - Pending Review 36 views 1 comment Most recent by Malaina Hudson Formulas and Functions
  • Multiple IFs then SUM
    In Formulas and Functions
    I have developed individual project sheets. In the project sheet I have multiple tasks. I want to populate number of hours I worked on each task, by summing the number of hours I worked on that project prior to a certain date. I keep all …
    Answered - Pending Review
    57 5
    Answered - Pending Review 57 views 5 comments Most recent by Aiman Shahpurwala Formulas and Functions
  • NETWORKDAYS Concern With Future and Past Dates
    In Formulas and Functions
    Working on creating schedule variance icons, I am running across an issue which might be solved with absolute values of NETWORKDAYS but wanted to understand how to better structure the formula correctly. In this example I have two helper c…
    Accepted
    43 5
    Accepted Answer 43 views 5 comments Most recent by Genevieve P. Formulas and Functions
  • Report Filtering on a Cell
    In Formulas and Functions
    Hi all, Is it an option to Filter out items based on 1 cell in a sheet? We have a project plan and there is a cell that designates the entire project complete that is at the top. Is there a way to exclude data from sheets that have that …
    Answered - Pending Review
    77 3
    Answered - Pending Review 77 views 3 comments Most recent by Paul Newcome Formulas and Functions