-
Formulas For Metrics
Good afternoon, Looking for some help on setting up formulas to capture the following metrics per attached. Any help would be greatly appreciated. Thank you !
-
Calculating a staged reduction in severity
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…
-
Dateformat changes in external linked sheets
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.…
-
Request: Video Tutorial for Filters
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…
-
Sort not correctly sorting manually-entered numbers
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…
-
RACI Sheet
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
-
Three separate views (permissions) against the same reference row
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…
-
Print report from Project and Task Management Template
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…
-
Percentage Complete Column (Breaks)
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…