-
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…
-
Time Tracking
I have been tasked with creating a time-tracking sheet to hopefully avoid looking elsewhere. We have various areas that work on the same project, so we need to track their work. I have started by creating a parent row (listing the name of the project) followed by the various columns of data we need to track. However - and…
-
Report to show all Project Managers without duplicates
Trying to create a simple report that will list all project managers from (3) sheets without duplicates. I can get the report to give me all the project manager names without any issues. The problem I have is it showed duplicate rows of the same project manager. I would be ok with a single project manager name entry with…