-
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
-
Automating which columns are displayed in a report
Is there any way to automate which columns are displayed in a report based on data entered into a worksheet? I suspect the answer is no but I'd like to confirm. I'm envisioning a scenario where I have a chart on a dashboard that displays financials by month, year, and quarter. It would be great if I could create an update…
-
Capture historical data for KPI dashboard
Having real-time data available for our dashboards and reports has improved our management capabilities. I want to be able to share how we have been doing over time, as well. I want to capture and report KPIs over time. I have a report that can capture the information I need but have been trying to figure out how to…
