Resource Views

Discussion List

  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    115 3
    115 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Having different colours for forecasted work in resource view
    In Using Smartsheet
    Hello, We are using smartsheet quite a bit now and need to highlight the difference between forecasted work and actual work in the resource view. I have seen previous questions on this saying it has been passed on to the development team…
    Answered - Pending Review
    23 4
    Answered - Pending Review 23 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Return to Work Templates
    In Staying on the Same Sheet
    Has Smartsheet created or does anyone have any locally successful templates for helping to plan out Return to Work from a manning perspective? Specifically, our government office is working to have a max capacity (20-30%) of total workfor…
    Answered - Pending Review
    84 2
    Answered - Pending Review 84 views 2 comments Most recent by Andrée Starå Staying on the Same Sheet
  • 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
    73 10
    Accepted Answer 73 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
    71 6
    Answered - Pending Review 71 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
    52 1
    Answered - Pending Review 52 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
    125 3
    Accepted Answer 125 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…
    74 3
    74 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…
    556 2
    556 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
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Genevieve P. Formulas and Functions