-
Why does the Sheet Summary SUMIFs formula show a different result than my report?
I am using this formula to report the total $ amount of past due projects, which rolls up to a dashboard for our team. =SUMIFS(Fee:Fee, [Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "1-Pre FMV Info Request") + COUNTIFS([Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "2-FMV In Process") + COUNTIFS([Key…
-
View "Today" line in Gantt on Dashboard
In a Report, I see a vertical line for "today's date" on the Gantt Chart. However, when the report is dropped onto a Dashboard, the vertical line is not displayed. Any suggestions?
-
Scatter Plot of Age
I have a smartsheet with many (hundreds) of events. On my dashboard, I would like to display a scatter plot of the age (days) of events as of today. I would like to filter the values, so that only events that are currently open display on the dashboard. I already have a column in my smartsheet with the age of each event…
-
Use report count value in dashboards
Hello, I am new to Smartsheets. I have tried searching in the forums, but couldn't get a resolution. Below is the scenario. In Folder - Project Type 1 Project 1 Project 2 Project 3 Using Summarise function of a report, I can get the count of number of projects in each folder. Can I use this count value in a Grid or…
-
Do I need to give permission for everyone so they can view widgets in my dashboard?
I have a dashboard that I want to disseminate out to some volunteers. I just recieved an email from a volunteer that said that he could not see the widgets in the dashboard even though he has access to the dashboard itself. Do i need to go into the reports that are in the widgets and share each one individually with him or…
-
Weekly Reports - Best Practices or Tips?
We need to send weekly reports in one email that pull information from a few different reports. We have it all on one dashboard, but I don't know of a way to send dashboard summaries by email. And they don't want to go to Smartsheet to view it there - it's got to be in an email. Ideally, they want the information in the…
-
Calendar App in Dashboard - remove list of calendars
I am embedding a calendar app into a dashboard using the web content widget. Even though I am using the direct link to the calendar, sometimes the full list of calendars I am shared to appears in the dashboard vs. only the calendar that should be displaying. Is there a way to embed the calendar so this doesn't happen? I…
-
I'm so happy with this landowner contact log system I designed in Smartsheet
Managing landowner communication used to be one of the most time-consuming and fragmented processes at our company. We relied on Word documents buried in server folders. Logging and reviewing landowner details was slow, only one person could edit at a time, and getting a full picture of a project meant manually opening…
-
Efficient Monthly Report Data Collection System for Faculty using Smartsheet
I am looking to create a streamlined system in Smartsheet to collect monthly report data from faculty members efficiently. This would include updates on publications, grants submission, presentations, etc. The main goals include consolidating all of this information in one place, providing a user-friendly interface for…