-
Calculate Working days with Multiple If Conditions
I have a scenario to calculate due dates with the following logic. LOW - Greater than - 7 days MEDIUM - Greater than - 4 days HIGH - Greater than - 2 days CRITICAL - Greater than - 1 day I have written the formula like this example - Low 7 days - Request Created On - 04/01/2024 will achieve the output date as 04/07/2024.…
-
Survey Results from Form to Dashboard Chart
Novice Smartsheet user here. I created a Likert-syle survey using a Smartsheet form that has about 20 questions on it. I have results from five respondents so far. I would like to present this data in a Dashboard using the chart widget - one chart per question. Ideally, the chart would show how many respondents answered…
-
Milestones on active project report
Hello, using the Active Projects report in PMO Template Portfolio view... Is there any way to get milestones to show on the Gantt timeline? I know you can drill down and get milestones report, put it in a separate project level view, etc. but wanted to know if there was a way to show the milestone diamonds on the rollup…
-
Dashboard widget is not displaying all of the data from the source report
Hello Everyone, Perhaps you can assist? I am the admin for our Smartsheet and have all permissions. I created all the reports and dashboards. Issue: Today, for the first time, a dashboard widget is not displaying all of the data from the source report. This is happening for all similar reports & dashboards. (See example in…
-
Customer Survey and NPS Scoring
I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculations ie. Intake sheet, separate sheet, report, etc. This is also my first "solution" build. Currently, I am putting the…
-
Help with Trend Data
I need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. Ex: How many projects are Red, Yellow and Green. This works really well for live data.…
-
WORKAPP VS. JUST A DASHBOARD
I have a Use Case where I'm deciding whether to use a just a Dashboard with Several Dynamic Views vs. setting it all up through a WorkApp. I have not used WorkApps yet, so am wanting to understand any advantages or features with using it. Use Case: Streamline our Single-Order process with a Key customer. [ They desired a…
-
Grouping with Parent Rows in Report
I would like to groups by quarter in a report, but keep the parents rows repeated in each quarter. Am I able to do that some how? When I use my quarter column to group all of the parent rows group at the bottom. For instance, my parent rows are Task 1 a - Q1 b - Q1 c - Q2 I want Task 1 to be broken into two groupings like…
-
Unable to enter data in a report
I have a row report that is pulling from one (1) single parent sheet. There are columns that are set up with either Contact list or Text/Number properties that will not allow us to enter data through a report. These columns are not locked and do not contain any formulas in the parent sheet. We are able to update a checkbox…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…