-
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.
-
Creating a new Report based on a single Sheet
I create Reports frequently and am comfortable with the process. What I'm wondering is if there is an easy way to create a Report from within a Sheet that is based on that same Sheet? I guess I'm looking for an option in the File menu that says Create a Report from this Sheet vs. starting a new Report and then selecting…
-
IT Portfolio Rollup
Hi Community, There have been numerous posts about how to essentially rollup multiple smartsheet projects into a portfolio/dashboard to show overall status information about the portfolio. I get the essence of the various posts, but before going down those paths to figure-out how to build something from scratch, I'm…
-
Email daily comments on (multiple) sheets
This seems pretty basic, so not sure if I'm missing something. But, certain project stakeholders like to receive daily status emails that show the project activity. When I say activity, I mean comments, not who changed which cell. Currently the only way I've been able to do this is the literally grab screenshots of the…
-
Column Not Found
Hello! When I am filtering down information from a sheet into multiple reports, a few of my columns are labeled as 'not found'. I haven’t renamed the columns, which I understand could cause this -although on one of the columns I changed the column type from 'symbols' to 'text' fairly recently (but not for my other one).…