Resource Views

Discussion List

  • Graphing Data
    In Formulas and Functions
    Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario:  Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from …
    63 0
    63 views 0 comments Started by cthrasher97141 Formulas and Functions
  • Rostering for Global Customer Support
    In Formulas and Functions
    Hi,    I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources),  who is on leave, time, names of the support person and who is on call. Also, includes …
    41 1
    41 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Will creating a baseline report duplicate resource allocation?
    In Using Smartsheet
    Hello, in Smartsheet's "Project Management Fundamentals" course, specifically in the section on Reporting, there's a great example on how you can compare the original plan (baseline) to actual project dates. The solution illustra…
    71 3
    71 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • Index / Match Multiple columns from another sheet
    In Formulas and Functions
    I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the …
    514 3
    514 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Permissions to edit cells
    In Formulas and Functions
    Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status.  The question is possible edit permissions on cells to avoid that any user coul…
    45 2
    45 views 2 comments Most recent by Mike Wilday Formulas and Functions
  • Best way of Counting a given number of States
    In Using Smartsheet
    Hi there, I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot. The only way I could think of for now was to get the data by cell linking and doing some calculations on it …
    63 3
    63 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • Sharing A Resource View
    In Archived 2016 Posts
    I have created various resource views by OBS and would like to share them with other users similar to the way it is done with a sheet. How do I share a Resource View?
    358 34
    Closed 358 views 34 comments Most recent by Andrée Starå Archived 2016 Posts
  • Calculating resource allocation for week or month view
    In Using Smartsheet
    As the resource view in resource management is only viewable by licensed users, and is in days, I'm interested to hear from other users how they were able to export data to excel and calculate for a week or month view.  I've tried to expor…
    545 5
    545 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Change week start day for resource views
    In Archived 2017 Posts
    Hi, We have changed settings everywhere we can find to have our work weeks start on Mondays. This has worked for sheets and reports but we can't find anywhere to change the start day of the week for resource views to Monday instead of the…
    267 5
    Closed 267 views 5 comments Most recent by Mattias Archived 2017 Posts
  • Individual task lists for unlicensed users
    In Using Smartsheet
    Hello, can an unlicensed user see a list of all tasks assigned to them (across different sheets)? Our resources are frequently unlicensed as they only have to view the tasks, so they can't create reports. I guess the project managers coul…
    33 1
    33 views 1 comment Most recent by Alejandra Using Smartsheet