-
How can i see who has changed which portion of the sheet?
Hi, I am having a situation wherein we are 2 Admins sharing the same Project sheet. I know that this is not the best way of handling the project/sheet. I would like to know, how do i see which portions of the plan is updated by my counterpart? I see a message that some changes are done and i need to refresh the sheet. I…
-
Pulling data from column on drop downlist
Hi, Is it possible to pull the data of "column-1" of "Sheet-1" to dropdown list in "column-1" of "Sheet-2" ? What actually my requirement is: I have a task list defined on "Column-1" of "Sheet-1". I need to create a RFI (Request For Information) webform for site engineers ("Sheet-2") where they select the task list from…
-
Excel spreadsheet with calendar and schedule
Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…
-
Custom View on Grid/Gantt
Often when I setout a new schedule layout I end up with a number of columns either auto- calculating, which I subsequently hide, or tracking finance, progress, comments etc and the view is busy... I'd love to be able to Save custom views, so I can select chosen columns to view. IE. Custom View 1 - Finance. Shows me the…
-
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…
