-
Task totals across multiple plans & within a set timeframe
Hello! My formula skills are pretty basic so I feel like this might be a bit more than that. I am trying to calculate the number of tasks for four departments across multiple project plan sheets. I want to look at a timeframe scale of the last 3 months and the next 6 months. The four departments are: Editorial, Design,…
-
Help to set up metrics on Project Raid Logs
Hi, how do i set up a metrics sheet to gather all information from our project raid logs. We have around 70+ Project raid logs for individual projects. I would like to create one sheet to display metrics such as - How many are red, Yellow and Green, Also which dept they sit in etc.. Im not sure if reports does this but…
-
Control Center - Add Row to Metrics Sheets
Is there a way to leverage control center to add a new row to all provisioned projects metrics sheets. I have a lot of projects that are already provisioned, and I can't go in and add the rows manually.
-
Median and Mode options in Report Summary Options
We use Median for a lot of metrics as it helps to remove the outliers that can skew the data. Please add Median and Mode (if you are already updating it 😉) in the summary options for the reports.
-
Realtime Metrics constrained by static columns and dashboard limitations
Smartsheet Community I have a dashboard for client that shows various financial and reporting KPIs/metrics for their business. One of the widgets they have requested is a 12-Month moving sales table that shows current month + last eleven months. I have figured out how to create the table in a sheet using various functions…
-
CountIF contains name from a contact list help needed
I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are listed as a scheduled staff member from the contact column. The formula I came up with only pulls results if that person's…
-
Dashboard Charts - Color Change Issues
Hello, I have had issues with my dashboard charts changing colors when values drop to 0 and then come back above 0. It changes everything and I have to manually fix this issue. I found a solution on the Smartsheet community site that recommended adding +0.0001 to the end of the value. This solved my problem but created…
-
Form Entry Metrics by Category
I'm creating a metrics sheet that will have data input by external parties via a form. I'm trying to think of a simpler/more user friendly way to display categories on the sheet and form. There are many category options and I need the # of occurrences entered for each category to tabulate monthly metrics. Most of these…
-
Formula to Display Top 10 Rows with Lowest Ranking
I have a sheet that captures the average rankings assigned to requests in order of priority. I need a formula to create a metric that displays the Top 10 request IDs that have the lowest average ranking (lowest ranking = highest priority). Here is an example of what I need: The metric needs to be dynamic as the top 10…
-
Dashboard
I have a metrics sheet that I send every Monday to leadership. However, I'm finding that I need to look at prior weekly metrics for comparison. Since my metrics sheet updates constantly, how would I capture that data without having to log it manually each week? I know this is a vague question. My formula knowledge is…