-
Clone sheet and reports between accounts
Hi there, I'd like to take a sheet and some reports that operate on that sheet, and clone them over to a new account programatically. I'm able to share the items, copy them, and then un-share them programatically, but the reports then point to a non-existing sheet. Since I have quite a number of reports I'd ideally like to…
-
Added row in smartsheet cannot be retrieved in reports
I have a sheet with all the data I need for reports, dashboards and other summary sheet. My trouble is, whenever I add a row in the source sheet, it is not reflect in my reports. Example, I have a report with a simple criteria/filter of retrieving any row with type = PROJECT. However, the newly added row is not reflected…
-
Reports not listing entries when it should
Hi there, We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects. I have just recently added few rows, all identical, on all 16 sheets. When I run reports, it does list certain rows (newly created). Puzzled, I simplified the report to the bare minimum: I now…
-
Enhancement Request: Improve Edit row from Report
Use Case: I have Sheet with lots of columns. Lots. 100 or more. I have a Report designed for a specific role and task set. The Report has a few columns. Two or more but less than 10. Limited view of the data. On the Row Menu, there is an Edit option that allows the user to see the Row in vertical orientation. However, all…
-
Is it possible to take text from Grid View and present it in a 2x3 format?
Hello, I just received a Smartsheet license today, so very new at this. I developed a form to gather information from users and automatically plug into a sheet. This will work nicely for capturing the data, but not so much for presenting the info in a meeting. Does anyone know if it's possible to take the text fields from…
-
Gantt Chart Settings Not Applying
Hi! I am trying to create a dashboard that has multiple gantt charts. I want the gantt chart to display from the current date, which is already an existing setting. I've checked the box on both my workspace, and the reports I am using on my dashboard, and for some reason the current date does not display. Has anyone run…
-
Lag between sheet structure update and Report Builder
I have seen this happen a few times .. I change the column names in a sheet and then go to build a report - the new column names are not shown in report builder. Sometimes it takes over 24 hours for the right column names to show up in report builder. See attached.. * Type field is shown twice in Report Builder * Task Name…
-
Editing rows from Calendar or Gantt view of report not working
When I attempt to edit rows by double-clicking a row in Calendar view or Gantt view of a Report, I receive the error-message attached. I have searched the forums and guides, and cannot see anywhere why this should not be possible. It occurs with all my reports in both Gantt view and Calendar view. Re-login does not help.…
-
Any Potential for Linking Reports to Sheets?
Hello, I wish there was a way to link a report to a sheet - does anyone know how to do this, or is it possible? I am hitting my link capacities for our production reporting, but what I really wish I could do is to sum a qty in a report and then graph it on a dashboard. Is there anything in the works at Smartsheets…
-
Current Month automatic
I am looking for an automatic way to generate reports that compare last month and current month. I have 6 account sheets that show totals by month and category. I would like to pull all 6 accounts into one sheet that shows last and current month totals by category. Can anyone provide guidance here? TIA.
