-
combining sheets
Hi, everyone! I would like to create a sheet or report that combines all of my other sheets so that I can look at them all together and sort by task. Ideally, this "master sheet" would update as each individual sheet is updated. Any help is appreciated!
-
Filter option after Building a Report
Hi, After building a report, it would be great if we had the ability to use filters similar to the other sheets. Thanks, Brent
-
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?