-
Graphs and Charts
Hi, I am fairly new with Graphs and Charts in Smartsheet. I am trying to create a monthly operating report with different graphs. An example is a KPI trend month by month. I am stuck at the first step: I have the raw data by day. I pulled them in a report and don't know how to average by month to create the graph by month.…
-
Is there a way to update source sheets for multiple reports?
We created about 30 reports. Each of them is taking the data from multiple sheets (each sheet is a project that our team is working on.). When we add a new sheet (new project), we have to go through each report one at a time and add the new sheet to the source data in the report template. This is very time-consuming when…
-
Report not filtering out all 100% complete tasks
I have a report to show me all of the tasks that are in progress (not 100% complete) or not started within a timeframe. Therefore, the report is supposed to filter OUT all tasks that at 100% complete. It has been working for over two years, with two different schedules. But now two items won't fall off of the report (the…
-
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…
