-
CONTRACT EXPIRATION DATE
1-I am trying to reference another to provide results of contract expiration date - 2- I would like to display in a dashboard the percent of total contracts that has expidered, will expire in 1year, 6month, 90 days 30 days, 14 days and 7 days 3- finally if there was an extension, to input that date in a new column that…
-
Ongoing Performance Evaluation Setup Dashboard - Form Won't Populate
Hi - I was asked to set up this dashboard: The template has been downloaded and the new workspace has been created. The form is set up, and when I did a test fill out of the form, the data went to the "Feedback: Positive" report, (which populated onto the feedback portion of the dashboard) but the data won't populate to…
-
Dashboards - Auto send PDF
Can I send a PDF of a Dashboard on a reoccurring basis? Recipients just want to receive by email on a regular basis and not need to login to view.
-
Is there a way to share a dashboard to multiple stakeholders but can only see information specific t
Is there a way to share a single dashboard to multiple stakeholders but can only see information specific to them based on email?
-
Count Cells that begin with a specific text
I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is there a formula to return the number of cells that have the first four letters as "ABCD"?
-
Dashboard Chart Errors for Other Users
Hi, I have created a dashboard with bar chart widgets - these charts are showing all relevant data for me, but when my colleagues (under their own smartsheet log-ins) open the dashboard, the charts are showing a 'data range cannot be shown' error. How do I make it so that the data can be seen by others with access to this…
-
Embedded Power BI in Dashboard
The log in button is not working when I am using Google Chrome in Incognito Mode. Is this a SmartSheet Issue or Power BI Issue? I can log in to Power BI service with no issue regardless of the browser and mode.
-
How to change metrics by row for Dashboard
Hi there, I have a sheet that has information for potential projects. Each project has a main row containing info that I have linked up to a dashboard. The idea is that I will pdf the dashboard with the project info, much like a proposal. I would like to make it so that I only have one dashboard and I can change the row…
-
How to show a simple List of items in a dashboard?
Hi, is it possible to create a list for all rows where "column 5" equals "management report"? This list should contain the value of "column 3" (report name) and the row-attachment. So that the list looks something like this: Sales report 05/2022 ......... File1.pdf, File2.jpg Tech report 05/2022 .......... FileXYZ.pdf Some…
-
Reset a Row
Hello, I am looking for a way to have certain cells in a row "reset" once a checkbox (in that same row) is checked. When I say "reset", I want two cells to go back to being empty and another cell to have an updated quantity. Is there a way to do this? Maybe multiple automations? Appreciate any help or ideas!