-
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.
-
Is there a way to assign a certain task/activity to multiple groups and generate report by group?
I want to use Smartsheet to track progress of task/activity by team or people. However, some tasks/activities may be assigned to multiple teams or people. For example, activity A to be done by x & y. Activity B to be done by y. Then, I want to create a report/dashboard to show all activities assigned to y (activity A & B),…
-
Report in HTML
Hi, i have a sheet with all manufecturing data including PO, drawings, documents etc. i want to generate a report for a few columns and give it to my client so they could track online what the status for there purchasing. i do not want to share with them the attachments file or comments - only view without smartsheet user
-
Creating a Report that ONLY shows rows with Attachments
Is there a way to filter out rows that show up in my report that do not have attachments? I'm building a report that shows my subcontractors any row that's had an attachment added to it in the last 7 days, but I can't seem to find a way to get the Report Builder to only show rows with attachments added. I realize I could…
-
Do formulas not transfer over to reports?
Hi everyone, I have a formula in my sheet that is not showing up on my report. It's a simple formula; how many days late something is, and I really need that info displayed in the report. Ideas, tips or tricks? Thanks! Ashley