-
Grouping info on reports
Hi all, I have 3 spreadsheets for which i want to report information from. All of them have common information/references (i.e. POW1234) but the name of the columns where that information is will be different from spreadsheet to spreadsheet. Is there a way to, on reports compile or group all the rows that have the same…
-
Can we create webhook on Reports like we do for Sheets
We can update the reports manually and since its bidirectional it updates the underlying sheet and vice versa. My question is whether we can create webhook on Reports or not like we create webhook for Smartsheets. If the webhook can be triggered on Reports it would be helpful for me. Please share your thoughts on this.…
-
Reports STILL not showing linked cells (grid) data
Is there an update on why reports are not showing cell data that is linked? Very frustrating trying to build a report and dashboard module.
-
Mindmap / Spider Web views of parent/child and relationship dependencies across worksheets
Hi Has anyone looked at or know of a way to create a more interactive dashboard of a mindmap / spider view of worksheet relationships and parent child dependencies within? I am using smartsheet to manage organisational OKR's and whilst I can create traditional grid/card and even dashboard views the OKR tools I am seeking…
-
Request for advice on best way to structure sheet column fields / data for reporting
Please give me your input on the best way to structure my sheet data to achieve the reporting/summary options desired. The current data is being migrated from an Excel workbook with ~20-30 column fields per row which makes it difficult to use for our project management/collaboration. But Thus far using the construction…
-
Can you reference the primary column with comments when exporting a report?
When you export a report into excel that has comments associated with rows, those comments show up on a separate tab in Excel. But the "Comments" tab only references a row number, which isn't that helpful when these are used as quick, high level reports. Having to try to align comments based on row numbers and flip back…
-
Report or formula to show time individual cell was changed?
We would like to be to see when (timestamp) changes are made to individual cells in a row without having to manually check cell history for the cell(s) of interest. Is there a formula we can use to do so? Or is there a report we can export to quickly be able to examine this data point without having to manually check cell…
-
Sending empty report
Hello, i have a question about reports. i have a sheet with tracking of my manufecturing per customer and i generate a report for status per customer. and every week on Sunday ths system send via email the reports in EXCEL format. my question is: in week that the report is empty customer has no products in production…
-
Report: Sheet Summary - Update Field from Report
I'm trying to find a workaround the lack of functionality in Update Requests. I have a Sheet Summary field called "Project Update" where our Project Lead is expected to put a brief statement on their project weekly. That field feeds up to the Project Dashboard and, subsequently, a Portfolio Dashboard to provide an update…
-
Select Specific Rows in a Report to create a Chart
Creating a chart in a dashboard: Sourcing data from a Grid sheet you can select, i.e. Row 4, 5, 6 BUT if you are sourcing from a Report, then you can NOT select ONLY rows 4, 5, 6 for example. Smartsheet automatically selects ALL rows in the Report to create the Chart. The report I have, contains around 50 rows, which makes…
