-
Dashboard with date range parameter but allow multiple users to view their own dashboard with differ
Hello. I made a Smartsheet dashboard which allows them to select a "From" date and a "To" date and allow a user to view the dashboard within that time frame. However, I am wondering if there's a way for more than one user to view this dashboard with their own date range without bothering others' date range when they view…
-
Populate multiple metric sheets with cross-sheet formula(s)
I'm looking to improve how I've set up several metric sheets to make sure data is staying up-to-date. The components of the workflow are here: Sheet 1 = This is the reference sheet that is used in reporting. Our billing department uses it to track claims. It's a basic sheet with a simple automation that moves rows to an…
-
Counting the number of items due in the next six months from today's date
Hi, I am struggling to find a formula that can count the number of items (each row represents a task/project) that are due in the next six months from TODAY (the date of viewing). At the moment the below formula is incorrect ... =COUNTIF([Target Closure Date]:[Target Closure Date], IFERROR(MONTH(@cell), TODAY(MONTH(+6))))…
-
Dashboard > Shortcut Widget | Editing a Shortcut widget not working.
Editing and existing widget does not show the current link/url and title. The fields shows blank, and updating them does work. I know its a minor thing and we can just create a new widget, but im just throwing it out there.
-
Word wrap in metric widget
Hello, Is it possible to have word wrap in a metric widget. I am currently pulling from a sheet summary and it does not display the entire text. Thank you!
-
RAID Metrics
Hello! I am hoping to get a little guidance. I am a little rusty on formulas and I have been trying to determine the count of "Open" items on our RAID log. We have Risk, Action, Issue and Decision that is a drop down option under our "RAID Type." Our "Status" column has a drop down option of Open, Closed and Canceled. Our…
-
Form Reports
Hello, We are using a form to track a task. The user responsible for completing the requests on the form receives an email notification to take action. Is it possible for a summary report to be sent out on a regular cadence so that the user can make sure he/she did not miss an email notification? If so, how is that setup?…
-
Dashboard Charts
I have developed a line chart that shows the monthly percentage values. The chart seems to be working fine, but one thing I've noticed is that in some instances it will display one or multiple numbers more than once. For example, the percentage values range from 97% to 99%. The line chart will show two tick marks for each…
-
Adding the template "Team Vacation Planner" to dashboard
Hi, The title says it all. I've started using the SS template called "Team Vacation Planner" and I was wondering how I could add this onto a Dashboard for quick viewing. I tried making it into a report but it only brought the columns; sheet name, created, created by, modified by and modified over. None of the names or…
-
COUNTIF + CONTAINS - how do I incorporate them both?
I'm trying to count how many times a value is used in a column. Sometimes the values are alone, sometimes there are multiple in a cell. I got my COUNTIF formula down: =COUNTIF({Christoph Comms Tracker Audience Category}, "Select SMG Employees") But I want to change it so it counts cells that include the value (along with…
