-
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…
-
Baffled......Circular / Blocked Reference (Vlookup)
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but I don't understand why my sheets work perfectly for periods of time, and then start…
-
Rotate Headers to a row instead of column
I am trying to create a report from data in smartsheet, but due to the amount of info on the report it becomes very small and unreadable when converted to a 1 page 11x17 pdf sheet. I was wondering if there is a way to make the sheet rotate the column headers to row headers to allow it be printed at a larger size.
-
Dropdown in Report
Hi Everyone, I have a sheet with a dropdown column. I have created a report and I want the team to update the data from the report instead of the sheet as the sheet has over 500 rows and data has to be updated in some specific rows. But the dropdown option is not available in report. Am I missing something or is it not…
-
Is there any way to use the API to retrieve resource allocations for users
It would be very helpful if the API was able to retrieve resource allocations for export into a report, but I haven't seen anything in the API documentation about this. Thanks.