-
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…
-
Net Promoter Score Calculation
Hi all, I'm stumped on a formula (again!) I'm looking to ascertain a NPS and I've got the following going on: Promoters: =COUNTIF([How likely are you to recommend NCR to a colleague]:[How likely are you to recommend NCR to a colleague], ">=9") Detractors: =COUNTIF([How likely are you to recommend NCR to a colleague]:[How…
-
Sheet/Workspace access request should go to owner and admin not just owner
We provision our project workspaces through control center and the account we login and do that with is a service account. Sheet request only go to the "Owner" which is a service account so the request are going to the Outlook account created for that, this isn't checked by anyone regularly and we are missing these…
-
Sharing a Filter By Current user report without sharing the sheet
Here is what I am attempting to do. I have a sheet where people use a form to submit requests. These could come from anybody in the company (over 100,000 people) I would like to have a report, on a dashboard, where these people can come in and see the status of their request. I was hoping to create a report, filtered on…
-
How do I access the eLearning Path via the Standard Support Add-on?
I am on the business plan and did the standard support add-on. I was told the eLearning Path for the Core App Badge is included with standard support upgrade, but when I go to the Smartsheet university and look it up, it still shows the $199 cost. How do I access the included Core App Badge course? Thanks!
-
Formula that pulls data from specific columns in a successor row
I found the row ID (not a column but the row id created by smartsheet) of the successor rows using the successor column. I'm struggling to figure out how to reference the smartsheet row id in a formula in order to pull data for the successor row for a specific column. The use case is a helper column that will show the…
-
Automation to move rows stopped working
I have an automation setup to move a row to another sheet when the status us changed to "Complete". This automation was working fine until I upgraded from Business to Enterprise. Now the automation does not trigger automatically, and when I trigger it manually it moves all rows from the source sheet to the destination…
-
Keeping track of old baselines
Hi I want to know if there is a simple way of keeping a log of baselines, e.g. each time it is reset, the old baseline is logged, similar to version control. The idea is that at the end of a project (which underwent change control resulting in the timeline needing to be re-baselined) we will be able to review the changes…
-
Average + Harvey balls
I'am new in smartsheet and I want to find the average score of my team in different areas using the harvey balls, and have the results measured via the spheres, I was trying to use the average function + harvey line but it gives me as a result error, thank you for your help