-
Sheet name in report (sheet name system column)
Hi, I have a Report that shows the Sheet Name (System Column). It's coming in formatted as Strikethrough with a colored background. Since there isn't a Sheet Name System Column available on the actual sheets, where is it getting this formatting from? Thank you.
-
Report not syncing when columns from source sheet deleted
Does anyone else experience the glitch where the columns on a report that were originally added with the report builder, but then deleted from the source sheet at a later point, are still showing up on the report as orphaned/inactive columns?
-
Top Level of Sheets in Report
Hi. The top level of my project sheets contain the overall percentage and status and date range of all its child tasks. How do I display just this top row in a report? My current workaround is to have a hidden column that a mark and have the report builder only show the row with that mark.
-
New Template(s) for The Public
I want to get this template to smartsheet for the community. Its for a family event with multiple data such as room availability, price, tax deduction, package and room assignment with form. Don't know how to donate this, but I would love to as its great for family get togethers. Won't do another one for 4 years cuzz it…
-
Reports
I have several reports built that pull from several sheets. I have rules created for a couple columns so that only specific lines are included in the reports. They all have 50 lines even if there are only 25 lines with information. The rest of the lines are blank and not able to be edited. I have other reports that are…
-
Is there a Japanese or Japanese company here?
Hello there, This is Kikuchi, working at a Japanese company in Tokyo, Japan. We are going to start smartsheet in our company and wondering if there are any Japanese users here? so that we can exchange the questions or experiences. Please let me know if you are a Japanese!! Thank you very much for your attention. Best…
-
What is the best way to consolidate data from multiple sheets?
I have multiple projects running side by side and I need a method to view a high level overview of all my projects with real data and a Gantt chart. I know I can use reports but reports do not support Gantt charts or a calendar. Does anyone have a better solution for how to do this?
-
Date selector on Sight - going back to past snapshot
Hi Smartsheet Community I checked a couple of posts but couldn't really find an answer, here we go: Sights are technically always showing real-time status. As I need to submit monthly updates to our leadership team and we want to track status trends, is there a way to re-visualize a past view of a dashboard? Or is the only…
-
Date and time stamp updated by day light savings
We have a number of Smarttsheets that are populated by web forms. The date and time stamp information that was entered prior to day light savings have now changed to reflect a "fictional time". In other words, an entry that was added at 6:00 am two weeks ago, now show a 5:00 am entry time. We need the historical…
-
Help: Change GANTT to Year/Month in Widget
I can change my GANTT chart in the project sheet to Year/Month display. But when I create a report and display the GANTT in a widget in the Sight it will only show the GANTT by Week/Day. I need it to show by Year/Month. Can this be done with the report widget? or is there another way to show the GANTT in the Sight for the…