-
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?
-
Update Request (form) 'Quick Button'?
Hi I have a large team of people updating a number of sheets. Within the sheets are a number of rows (risks and issues), each one has it's own ID. Whilst the sheet is shared and I have some of the columns locked, I want to be able for a user to review their risks and issues and then to click an 'update' button so that they…
-
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…
-
Recurring Update Requests by Contact
I have a sheet that serves as a team pipeline report and I would like to have a weekly update request where every row assigned to a specifc person is included automatically in the request. Each row has one designated person in charge and I would like for them to receive the notice to update each of their projects in the…
-
Sights
I am new to Smartsheet so I apologies in advance. I have used sights (dashboard) for a single sheet, however I can't seem to create one for multiple sheets, is this possible? If so, I understand that sights simply pulls the information from a sheet and does not allow any calculations, however It would be great if the…
-
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…
-
I would like to hire an experienced consultant
I am relatively new to Smartsheet. I need someone to help setup Smartsheet to manage our book production schedule. We publish books (print and e-) and have managed our production schedule for many years with a Google Sheet. It is severely lacking. I have not yet signed up for any plan. I don't think I'll need 3 licensed…
-
Projects per sheet?
I have 10-12 projects each year that will use the same project steps. Is it better to create one sheet to house all 10-12 projects and seperate them using the parent/child relationship. OR, is it better to create one sheet per project? I'm also thinking about how this will report up to a Smartsheet Sight for status updates.
-
Managing Resources by duration and not % allocation
Is there a way to manage resources by time rather than having to use % allocation please? Any way aound this? Its actually not that easy to manage using a %. Sad that smartsheet didn't think it would be an important feature. I'm no software expert, but seems like not too difficult a fix if they already implemented it for…
-
Hiding Rows, Columns from Client or User Access
Hello. I've searched and thought but I want to ask the question anyway: Is there some way I haven't found, to hide a row or group of rows (or only show the ones you want) from a user or published view and keep those sent rows in an interactive environment? Heres the situation: Out of my 200 row sheet, I only want to show…
