-
Duplicating a sheet has doubled each resource usage
I have created a sheet of activities and then allocated resources to each task as normal. I then wanted to keep this sheet as is, as a template. I made a copy of this sheet to do some "what-ifs" scenarios on this sheet and keep the original intact. However in the Resource View, each resource is picking up the utilisation…
-
Sights Sheet Data Widget updating question
I am looking for a way within the Sights, Sheet Data widget to update the selected cells as rows are added to the source sheet. Do we know of a way to accomplish this? Any suggestions would be appreciated. Thanks, Bill
-
Large doc with rows of data - dates
I have a sheet that we use to co-ordinate service work. It is getting pretty big. Is there anyway to have Smartsheet automatically go to todays date on the sheet, as opposed to starting at row 1?
-
Hiding Columns
We have a purchased items tracker sheet for a project. Is there a way to make the price column visible only to a couple of people and nobody else without using hide/unhide every time I need to see it or use it?
-
Setting Non-Working Days based on Assigned to name
Hello, I have a rather odd question that I'm not sure if anyone else has dealt with. We have a project with team members located at different facilities around the globe. As a result, we have different holidays associated with the various regions (EU, USA, Asia Pacific, etc) that will impact the working days available for…
-
Resource Management
I am starting to evaluate resource management using Smartsheet. What I have been able to determine so far is that a resource must be assigned and allocated to a task in order view allocation % across projects. Is it possible to set up an organizational view where I can view all resources in my group and see to which…
-
Use more row content as the default text of the subject field when sending a quick update.
We would have a huge increase in productivity if we could use more than just the primary column row content as the default text of the subject field when sending a quick update.
-
Priority rows
How do I insert a priority row and lock it. thanks Kurt
-
Date Counter for Weekly Ontime Rate
Hi there! I need some help coming up with two formulas that will count how many times in the week we hit our projected due date and how many times we are early. I already have a hidden column that looks at the date and calculates the week of the year. I need the fomulas to read something like: count if 'date completed' is…
-
How to get team involved
What are some ways that you are implementing Smartsheet into your company, team, etc.? I am the creator of the Smartsheet system in my company. I have found that because I have spent so much time in the sheet I have a gap between me and my team that is difficult to close. It all come down to how we get our people into the…