-
Reference Sheet Summary data from another sheet
Currently if I could like to reference another sheet in either a cell or in a formula elsewhere, that data must come from a sheet and not a sheet summary. This means I have some data duplicated in a sheet summary for a report, and also in a sheet for use in a reference elsewhere
-
Sheet Summary Report Chart
I continue to get an error when I try to create a chart of a Sheet Summary Report. The error states "Selected Data can not be charted. Please select a new range". The data is pretty straightforward, its a list of 15 locations with a completeness between 0 and 100. I tried removing the percentage in my sheet summary…
-
Failing to post date value to Summary field
I am working with the python sdk, and I cannot figure out how to post a date value. Here is a picture of what I am doing. where sum is a dictionary of posting data If I am trying to post a formula, I check that my "Posting value" has a equal sign, and then the formula goes there, and it posts fine. If I am trying to post a…
-
Is there a formula to get the average of star ratings?
I have a column that is only star ratings. I am trying to the get the average rating of the entire column in a sheet summary field. I tried to just do the average formula for the column and got the #DIVIDE BY ZERO error. Is there a formula that can calculate the average without having to create a helper column to translate…
-
'Lock' a sheet summary field or workaround for a copy-and-pastable value?
Hi folks, I have a sheet summary field that pulls a value into my sheet from another sheet. It's a weblink although in theory it could be anything that someone might want to copy and paste rather than just read. The link pulls through as expected but when my users (who are editors, for they are required to edit other items…
-
Formula no longer working in Sheet Summary
I have a sheet with sheet summaries that were working for the last month and I recently updated with data shuttle and its no longer working. I keep getting the sum of 0 even though it was working before. =SUMIFS([Quantity (G)]:[Quantity (G)], Material:Material, CONTAINS("200002", @cell), [Pick-up Date]:[Pick-up Date],…
-
COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
-
Update formula wizard when used in sheet summary
This is because the wizard only offers 'Reference another sheet' when this is slightly illogical as you are in sheet summary ie to summarise the sheet you are in. You then cant click on the column header to add the range to the formula when using sheet summary without an error. The way to add the range is to scroll down…
-
API endpoint for summary information reports
Currently when using the Smartsheet connector for Power BI, is not possible to grab sheet summary information reports, only reports based on sheet row line information. It would be very good to be able to gather information from summary based reports on Power BI.
-
Is it possible to create dashboard charts using Sheet Summaries?
I know Sheet Summaries can be used to create Metrics widgets, but when I try to create a chart, there is no option to select a Sheet Summary as a data source. I thought the whole point of the summaries was to eliminate the need to add formulas and metrics on the sheet itself (or to a separate report). Am I missing…
