-
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…
-
Index Match Formula help. Index Match of Health status of an activity into Sheet Summary
I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health symbol. =INDEX(Health:Health, MATCH("Task A",…
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
Formula Help Please - Sheet Summary
Hi everyone - I have a GIANT sheet I'm working with that contains our project portfolio. I need to add summary fields to capture Project Status (from a dop down field in a column) across 10 different Sponsor Divisions (also in a drop down field within a column). I can't seem to crack this one. Can someone help? I'm sure…
-
Display 2 dates in one sheet summary field
can I display both a start date column and end date column value in ONE sheet summary field IE start date column in sheet 11/7 end date column in sheet11/14 Sheet Summary field 11/7-11/14 Help please :)