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…
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 e…
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 …
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…
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 c…
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 …
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 th…
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 fol…
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 co…
Dear reader, We have 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 no…