-
Calculating averages based on specific criteria per week.
I have a smartsheet that I am trying to find an average rating per week if there is specific criteria in a column. I've condensed the columns I'm trying to find an average of below The 'Created' column is an Auto-Number column for when the data is entered. I'd like to calculate the average, or 'Over All Rating' for each…
-
Report showing Yesterday's form submissions, only if not a weekend
I've got a report showing form submissions from YESTERDAY, but on Mondays, the report will be blank. I need it to show the previous work day's submissions (it calculates an average daily score). Is it possible to filter this report to show the last WEEKDAY's submissions? @Paul Newcome
-
Is there a way to use automation across grids?
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to add data from another sheet so that once we receive a request the automation can reference the requestor's job function and…
-
Dashboard report not showing in Desktop
I have a report in gantt view that is not showing in a dashboard online. I'm using Chrome to access. The source sheet, report, and dashboard all are published with read only full permissions. When I pull up the website in view only using the public link, I get the the following... Is there a workaround so that the report…
-
Reference Entire Sheet AND Filter Rows Where Column Value ="Search Value"
I am simply trying to do the following: - Refer to another sheet (ALL ROWS and COLUMNS) with the following conditions: - Where in Column [STATUS] is = "Done" The RESULT should be: - This new sheet shows all rows and columns from another sheet where Status is Done.
-
Limit access to underlying sheets using Dynamic View
In my organisation, I have designed our Smartsheet solution so that all stakeholders use Reports to fulfil their daily tasks, the only department needing to access the underlying data sheets is Project Management. Is there a way using Dynamic View I can restrict access to the underlying sheets to everyone other than my…
-
Looking to see what reports use a sheet
I sheet of data which is used across a number of reports, is there a way from the sheet i can see where its being used ?
-
Is there a way to Add Filters to Pivot Tables?
Hi - I'm in the process of creating a "Request Tracker" sheet with associated reports & pivots to serve up to a dashboard. I want to create a pie chart that breaks down "Request Type" but only for open requests (meaning, the Status is not one of "Completed" or "Cancelled"). So my question is, is there a way for me to…
-
Including Parents in Report
I'm creating a report and filtering by the value in a particular column. However, I would like to see the parent rows as well. In the original sheet, I can create a filter and check the box that says "include parent rows". However, in the report, I don't have that option when selecting a filter. How can including the…
-
Get Month and Year and Group/Sort
I've got a sheet in which sales reps input their daily activity. This sheet has a date column that is required. I'm trying to make a dashboard to track month to month levels of activity. Perhaps I'm missing something but there doesn't seem an obvious way to do this. I've tried making a report to group by month and sorts…