Within each project we utilize Sheet Summary to pull into reporting and ultimately dashboards. There are a couple fields that I would like not to be manual, but instead use some kind of formula if I c…
Is there any way to find out how many sheets in my account are using forms? (Short of opening up each sheet and clicking on Manage Forms! We have way too many sheets for that!) We need a way to estima…
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…