-
automatic notifications when dates are passed
We created a new sheet for tracking our work and have a cell with a due date for design submittals. There is an empty cell next to the due date that we want the user to add either a check box or date to show the submittal was actually done. The question is, if the date or checkbox isn't filled out after the due date has…
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Report Builder - Not Sorting Dates
Hello - I running reports for partners on the team to provide the user a snapshot of tasks due earliest date to latest date. When I sort A to Z on the finish date it is not working. Any ideas
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…
-
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…