I am trying to set up a way to track manpower 50+ people plus projects that are ongoing.  

2 separate sheets are fine - 1 project summary and 1 manpower.

How can i set it up, that i can see who is available, when workers will be on vacation and it will notify is someone is booked for one project so


I am trying to total points based on the persons name.  Basically one column has the names, some of them duplicates.  Another Column has points.  I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the



as a part of knowledge migration project in our company, we're storing links to the documents in a tracker on Smartsheet. When opened from smartsheet the links work properly. Unfortunately, when I export the tracker to excel - I am not able to open any of them. Could you advice what could go