- Countifs plus a date range?
Hello, My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc. How do I write the formula for the date so that it includes all days of each month? =Countifs [Adjusted Due date]:[Adjusted Due Date],…
- Need to Tally and List Unique Values From a Drop-Down
Hello, I have a sheet in which I am tracking distributor complaints. I need to make a few different graphs. One of which is supposed to be a line/tally graph of how many complaints have been made by each distributor. We have a list of almost 40 different distributors which we have in a drop-down select form, for the ease…
- Client facing dashboard
I'm working on a client facing dashboard, that the client would put information in. From what I can tell this is not going to be pretty from the clients side. I have to share the dashboard. I have to share the report I created that is on the dashboard. I have to share the original sheet that the report above is created…
- What is this widget and how do I create the same?
Hi, I was in a meeting with an external team today who used a dashboard to show Open tasks. In the widget, a user could drill down into the widget and add/view comments without having to click through to the origin sheet. Does anyone know how I can replicate this please? Many thanks
- Surface row report data to dashbord
Is there a way to surface a contact from a row report to a dashboard? When I go to add using a metric the row report is not accessible. I note that the row report is accessible to surface data for a chart. What am I missing/not doing?
- Duplicate Dashboard but with Date Filter
Hi, I am looking for ideas on creating a filter for date ranges in a dashboard. I want users to view the available data in a dashboard by quarter (three months of data). I have a dashboard built that contains all of the data for 2021 that is fed from a single sheet. I intended to continue adding rows to the same sheet for…
- How to make a sheet that only shows the last x entries of another sheet
Hello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display this in a chart, and that is where I am running into troubles. For the line graph widget, they would like it to show the last…
- Dashboard chart from sheet
Hi all, I am trying to create a dashboard chart widget on my RAG status. I have used the symbols in the sheets (Red, Amber, Green, Blue. However, when selecting this data via the widget, I get the following message "the selected columns cannot be charted...." Any advice if I can do this or it just isn't with the…
- Question on Dashboards
I am trying to create a graph on my dashboard that shows a month by month historical trend line graph. When I try and graph out the info it sorts the months by alphabetical order rather than in the correct order. I have 2 columns on my source sheet pulled into a report one that shows the date an item was entered and I have…
- Form columns update other form column
亲爱的读者,我们有developed various forms (per service) to map the use of our services by our customers (Non Smartsheet User). The customer must enter his company name on every form, but this is not desirable if a customer submits all different forms at the same time. Is there a possibility to develop one form where the…
