-
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…
-
Formula return Column date plus 7 days IF column value is less than 3
Hi, I am new to smartsheet (spreadsheets in general) and I am trying to create a task list sets a due 7 days after a task was created if the priority of that task is less than 3. The formula i have so far is: =IF([Priority]1 < 3), [Created]1 + 7 I get an error saying Missing or invalid parameters. I'm not sure what im…
-
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.