Resource Views

Discussion List

  • Calculate new start time for whole schedule
    In Formulas and Functions
    Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new sta…
    Answered - Pending Review
    19 1
    Answered - Pending Review 19 views 1 comment Most recent by Ramzi K Formulas and Functions
  • How can you share a report without giving access to the sheet?
    In Using Smartsheet
    I have created a time tracking report for all employees utilizing a weekly form each completes. As I don't want employees viewing other's time, I created a report for each employee so they could see their own time collectively and make ch…
    46 3
    Accepted Answer 46 views 3 comments Most recent by Madyson Morris Using Smartsheet
  • 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…
    133 3
    133 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
    30 4
    Answered - Pending Review 30 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
    113 2
    Answered - Pending Review 113 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…
    97 10
    Accepted Answer 97 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
    107 6
    Answered - Pending Review 107 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
    64 1
    Answered - Pending Review 64 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…
    199 3
    Accepted Answer 199 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…
    91 3
    91 views 3 comments Most recent by Chris Atkinson Formulas and Functions