-
Need to pick the right solution to start a project. Need Dashboard that receives updates...
Hi All, I am new to Smartsheet and need to setup a new project. I've been told the stakeholders want to view a dashboard that updates from Task Trackers from various departments. It is a large project with HR, Payroll, Tax and Insurance, Finance and Information Technology all doing a piece of the project with their own…
-
Dashboard Report Metrics - remove column headers
Hey Brainstrust, I am wondering if there is a way to remove the report column headers from a report metric on a dashboard. We add our own hearders into the grid so we can change the formatting of the column headers (centre, change colour so they stand out etc). But obviously this looks a bit odd when there are 2 sets of…
-
I just want to have a running count of entrants in a column so that I can pull this data to a dashb
I just want to have a running count of entrants in a column so that I can pull this data to a dashboard. I have been playing around with the sum and count and sumif and countif functions. I want the data to be live so that is another person submits the form (the data is from a checklist) the dashboard widget will update…
-
Block Submissions According Quota Met
Hi! I wanted to see if there is a way to block date submissions on a form if a quota has been met on the SmartSheet? For example, we are utilizing a form to submit for summer weeks. The max for each week is 4, so if a week already has 4 submitted, I would like the user to be blocked from submitting that date. Is there a…
-
Dashboard Funcionality
Hey, friends. Long time listener; first time caller. I'm stuck. Here's what I'm trying to do. I have created a stacked column graph that shows a scale of potential values in several different categories. Example: for "Blue", 0-68% is poor, 69-75% is acceptable, 76-85% is good, 86-100% is exceptional. Then there are…
-
Splitting Single Sheet Horizontally to have two separate scroll bars
Hello, We have a request form that needs to be split horizontally to allow for two different categories of jobs. Excel does this pretty easily, but I don't see a way to split a sheet horizontally. Creating a report or dashboard will not work in this instance. Thank you!
-
Where did they go?
I have created a couple new templates with a workspace titled the same and they have disappeared in the Desktop app. I can log into the website and they are where they should be. Thoughts?
-
Assign multiple people to a row, based on multi select drop down.
Hello, I have a dropdown where the user can select multiple customers. I need to assign the person or people responsible for the customers selected. I have a customer list sheet and each row is a customer, the customer managers I am trying to pull in are on this sheet. So I need the formula to look at all the customers…
-
Data Shuffle Date Formatting Issues
Using Data Shuffle to import data from excel into Smartsheets on a daily basis. When there are dates in the column, sometimes but not every time the date format will shift between US (MM/DD/YYYY) and UK/EU Date format (DD/MM/YYYY) when uploading. Has anyone come across this issue before and how I go about resolving?…
-
Chart Widget on dashboard
Hello, I have created a report in order to create a chart widget in a dashboard, which I did, but because the variables are 2 large categories, this looks very big and it doesn't look good on the dashboard. What I would like to display on the chart widget is how many types of transactions are by location since the…