Resource Views

Discussion List

  • Importing from Excel to Smartsheet (Grid) using names for contacts
    In Formulas and Functions
    I am trying to import an excel spreadsheet where I have names in a column on each row. The names are formatted as FirstName<sp>LastName, and they are being imported then the cells are being referenced in other SS grids. I would lik…
    Accepted
    63 10
    Accepted Answer 63 views 10 comments Most recent by Genevieve P Formulas and Functions
  • Resource Management Tool
    In Using Smartsheet
    I'm looking at how I can migrate project plans (Omniplan) into Smartsheet to then use the resource management element to see people's capacity and adjust the schedule to smooth delivery. Has anyone done something similar or have any learni…
    Answered - Pending Review
    74 6
    Answered - Pending Review 74 views 6 comments Most recent by SteCoxy Using Smartsheet
  • Row and Sum calculations for Capacity Management
    In Formulas and Functions
    So, until we get 10k feet, I am trying to figure out how much of our team's capacity is spent on projects or operations work. In the sample below, I'd like to know how much time teams and sub teams spend on Projects, Operations, Enhanceme…
    Answered - Pending Review
    44 1
    Answered - Pending Review 44 views 1 comment Most recent by Peter Harink Formulas and Functions
  • Resource Views not Showing assigned tasks
    In Using Smartsheet
    I have a Smartsheet with resource management enabled, users that the sys admin set up for three teams, and a resource view by "user" that filters for just those three teams. Yet still the assignments do not show up in resource v…
    Accepted
    94 3
    Accepted Answer 94 views 3 comments Most recent by Stefan Using Smartsheet
  • Elapsed time - 24hr workday - Display bug?
    In Formulas and Functions
    See the attached pic.    * The sheet is set for 24hr workdays.  Mon-Fri.    * There are 2 tasks.   one with duration 7d  and one with duration e7d. * The e7d  task does not display 7 days of working.  The gantt chart bar does not show sun…
    64 3
    64 views 3 comments Most recent by Chris Atkinson Formulas and Functions
  • Resource Management info in a dashboard
    In Using Smartsheet
    Hello, I am creating a dashboard and I need to add a resource view to it, to show the resources assigned to a specific project. Is there any way to do this? Also in the resource view, is it possible to limit the projects considered to ca…
    510 2
    510 views 2 comments Most recent by bowser5 Using Smartsheet
  • Verify All Sites Submitted Response Today
    In Formulas and Functions
    Hi, I'm trying to track if a site (or Name) created a new daily entry using a Smartsheet form. I added this formula to the Updated Today column to return a "Yes" answer if the site (or Name) created a new daily entry. This seems…
    Answered - Pending Review
    23 1
    Answered - Pending Review 23 views 1 comment Most recent by Genevieve P Formulas and Functions
  • Is there a way to stop 100% completed tasks still showing in Resource Views
    In Using Smartsheet
    We use Resource Views to show capacity loading for each department in our factory. Not sure if this is possible, but it would make sense to me if when tasks allocated to a particular resource were marked 100% complete they would no longer …
    Answered - Pending Review
    33 4
    Answered - Pending Review 33 views 4 comments Most recent by Richard Rymill SBP Using Smartsheet
  • Compare the hours allocated to the hours actually worked, through timesheets
    In Formulas and Functions
    Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which proj…
    Answered - Pending Review
    83 2
    Answered - Pending Review 83 views 2 comments Most recent by Gordon Formulas and Functions
  • Proofing- Previous Versions
    In Using Smartsheet
    Hello everyone,   I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still down…
    Accepted
    93 12
    Accepted Answer 93 views 12 comments Most recent by Andrée Starå Using Smartsheet