-
Trigger notification/update request based on time elapsed since last comment or action on a row
We're using a ticketing system and trying to find a way to trigger automatic update requests when a ticket/row has been unacknowledged for more than 12 hours. Currently we're using the comments feature to post updates to the ticket across shift changes. How can I set an alert to go out if there has been no comment on a row…
-
Sending multiple sheets as one attachment
Hi All, Is it possible to send multiple sheets (all in the same workspace) as an attachment? The reason I ask is I have 8 reports which will all need to be sent on the same day each month and I was hoping to avoid having the the client recieve 8 emails each time. Pdf of excel is fine Thanks, Soph
-
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…