I have a dashboard created with a "Data Date" Metric at the top. Using the Created column to populate a "Data Date" column (text column +LEFT(Created@row, 18) I can add the date in the metric via a sh…
I am trying to create a count of how many rows in my sheet meet a certain criteria. I created a Sheet summary field and used the COUNTIF Formula. However, it keeps returning #NO MATCH when there clear…
I have a summary sheet set up for my projects, which is connected to a metadata sheet I have. In the metadata sheet, I have column types for different types of data (contact, text/number, date, etc). …
I am using row reports and sheet summary reports. When I create a row report , I can edit fields in the report and it updates back into the plan /sheet itself. This makes it easy for me to meet with a…
When exporting a Report to PDF or Excel from Smartsheet, grouping and summary rows should be included. As I utilize a lot of automated reporting, via PDF, this would create consistency in the report v…
Is there any update on when reports might keep the grouping/summary rows when sent as an attachment or displaying on a dashboard? I remember hearing this was 'in the works' back in February.
There's an email that contacts on a sheet receive towards the end of the day when changes are made to a sheet. They'll receive the automated emails set up on the sheet as well as this summary of chang…
I'm trying to build a Summary field that pulls in the StartDate and EndDate. I'm using this formula: =[Start Date]# + " - " + [End Date]#. Does bring in the data from the two fields, but it includes t…
Hello, I am thinking this is an easy question with an easy solution. I have a Control Center blueprint where I have mapped a column incorrectly, Text instead of Contact. The data is coming from the me…
I am trying to create a reporting dashboard that displays elements of a row when a value in that row is "Yes". For example, if a workstream is blocked, the reference cell is "Is Blocked?" and if the v…