-
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…
-
Has anyone found a good way to visually display daily metrics for the month?
I work in manufacturing and I am trying to build a dashboard for our tiered meetings. I know some people might be familiar with what I am building as it is common in the industry. I have several sheets where Safety incidents and quality incidents etc. can be submitted. My management wants me to build a dashboard that will…
-
Best way to compile rolling metrics for Dashboard Update
I'm working to build a dashboard that presents monthly metrics. I want the dashboard to automatically update to display the last 12 months' metrics. I have a metrics spreadsheet that calculates all the information for each month. I'm wondering if the best way to achieve this is to create a new smartsheet with a formula to…
-
How would you measure progress by quarter
Hi there, I am hoping to crowdsource some creative answers to a question that has been asked of me by my leadership team. I currently have a Project Management Office/Organization set up in Smartsheet where projects come in with a request form and are managed on an intake sheet, get their own project planning grid &…