-
Smartsheet Project Management, gaant chart, resource allocation
Hello, I have an Excel spreadsheet with 50 projects, multiple resources that I need to convert to smartsheet. Do I need to create one smartsheet for each project? I will be needing the following data from the sheets: Gantt Chart Resource utilization - Can I assign more than 1 resource and still get tracking info? Milestone…
-
Report Builder - 'Who' Functionality
Hello, I'll preface this by saying that I think the answer is no, but I wanted to check for other people's thoughts. In our project plans, we have a Project Manager field that lives in a Contact type column. There are many projects we run where we have multiple Project Managers assigned. Each PM has their own dashboard for…
-
Can someone send examples of a user policy and access provision form that you have developed?
I need to develop a provisioning/deprovisioning form to be used by our internal staff as well as our external vendors that will be uploading data and documents to our new Dynamic View Smartsheet. I've seen one other question similar to mine, but it didn't offer useful or relevant information. I'm hoping someone has had to…
-
Reassign a task
I have a sheet which has many different controls with owners assigned (and also a delegate column) which need to be updated on a frequency. I have created a report with "current user" so those assignees can log in and see only those assigned to them for updating. It appears that any drop down column can not be updated via…
-
High Level Project Report
Hi Everyone, I'm looking at creating a high level/overview report for around 10 ongoing projects which are all on their own Grids in Different work spaces with what stage they are at, who is assigned to the project and the date they are due to be complete. Can anyone recommend how I can do this, as I am very new to…
-
Dashboard Preview
in Dashboard, i'm trying to compare the data preview between "Edit mode" and "Preview in publish link", i found the difference information time on "created date", please advise.
-
Video: Smartsheet Interface Basics
I probably just didn't use the right search terms in the Smartsheet Support system, but I was surprised not to find anything dedicated to the users of the grids we create. Lots of good content about how to build in Smartsheet, but since I couldn't locate how they launch new users (ie, the consumers, as it were, not the…
-
Show schedule gaps in parent Gantt View
Hello, Is there any way to show the gaps in the schedules for child tasks in the Gantt view. Currently, the parent shows the minimum and maximum dates of the child and displays a continuous graphic, even if there are gaps in the schedule of the child tasks. Can anything be done to display these schedule gaps in the parent…
-
issue applying conditional formatting to "% Complete" column
I am trying to write a formula that will change the symbol in the status column based on the percentage, as indicated by the "Complete" column. I cannot get my sheet to respond to any of my parameters. I have tried these formulas: =IF(Complete@row < 30, "Red", IF(Complete@row < 60, "Yellow", IF(Complete@row = 100,…
-
Issue applying conditional formatting to a symbols drop down
In the far left column of my sheet I have a "status" column which is a dropdown of yellow, red, and green symbols which indicate the general status of the project. I would like to apply conditional formatting which will automatically change this column to red/green/yellow based on conditions in the "difference" column, on…
