-
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…
-
Datamesh to Update Engagement Progress for Coaches and Clients
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to report the dates of each session in the engagements. Due to the nature of this environment, coaches can report any number of…
-
Contract Managment
Has anyone created a smartsheet to manage contracts?, specifically to perform the below activities: * track total amount vs. payments * track payments against deliverable complete * track contract term * track contract amendments : to extend the period, increase the budget, adjust terms of reference, etc. * Track invoices…
-
Cloning Filters
Hi! I am setting up smartsheet for different departments in a company. I have 10 filters in one sheet and need the same filters for a different team on another sheet. Is there a way I can clone the filters just as in conditional formatting to be used in other sheets instead of repaating the same process again? Thanks!
