I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigation planning (score of 1-5) and then have that drive an auto-calculation of the final score of the Risk. Unfortunately I am…
I've created a table to manage our school-year. Out of this table several calendars should be created. As there is no possibility to create more than one calendar out of one tablesheet I worked with markups and created external links to some other tablesheets so that there is one sheet for every group I have to manage.…
Could Smartsheet add a brief how-to video on filtering to the help article? My team is asking for one and I can make it myself but I think the quality of Smartsheet's videos is excellent and would love to give them something more professionally done. It should demo how to create a filter and illustrate the difference…
I've got an auto-number column in one of my sheets, which has data from an excel sheet that I used prior to smartsheet. Most of the numbers in the auto-number column were from historical data and needed to be identical to that excel sheet, so I changed the column type to text/number, inserted the data with the excel's…
Hello, I am trying to get this exact sheet. The very first one Can someone please send it to me so I can use it to make edits. Thanks https://www.smartsheet.com/comprehensive-project-management-guide-everything-raci-b
Hi What is the best way to do the following, without the expense of Dynamic Views please? Have a reference that is common in three sheets; that if you add, edit or delete this reference row, the changes get reflected in all three sheets? It is so that I can do three views to three different sets of people who can only see…
Hi, I have created a sheet utilizing the project and task management template and would like to print a report that displays only select columns of the sheet for use during a status meeting. I would like all rows to print, but only some columns. Is there a way to do this? Currently, we are hiding the columns and then…
Greetings, I've discovered that the % Complete Column in a few of my sheets has broken, is incomplete at calculating the true completion percentage for a project. I suspect this might have happened somewhere along the line of adding/removing rows. Is there any way to see/edit the formula to ensure it is counting all rows…
How do you guys manage issues for a project? I'm wondering a way to attach (or associated) a issue (could be task) list at a project sheet level. Thanks!