-
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],…
-
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…
-
Merged: Export a report as shown with formatting in Smartseet
This discussion has been merged.
-
Why are my Blueprint Summaries blank?
Hi All, We recently started using Smartsheet CC. We had 5 blueprint summaries created and they're all working fine. I wanted to add a new column to one of my blueprint summaries, but when I went through the Blueprint Builder, the blueprint summary section now has blanks for sheet selections when just yesterday the 5…
-
SCC Fails to update links error
One issue we are having is automation from SCC at job creation to send specific information from a project to Intake sheet. Here is what logic we applied and the error we get, can you look and maybe advise a solution for us? On Intake Sheet, we have the fields “PS Start Date” and “PS End Date” that are set push from…