-
Single-row reporting from multiple sheets
In the reports I've used so far a new row is created for each sheet data is pulled from. Is there a way of combining the results on one row where the primary column is the same? For example, if I have project RAG status in Sheet1 and project financials in Sheet2, and both sheets have the identical project name as the…
-
Centralizing rows assigned to individuals across multiple Workspaces
I have a project management workspace template that I create for each identical project (business startup). There are a number of items that are assigned to a group of individuals by department (HR, Procurement, EHS etc.). I used to keep all projects in one workspace and was able to create a report that would pull together…
-
Totals of column data
Is there anyway to total columns other than using a parent?
-
Filter what other can see&edit
My Company from Slovenia is using SmartSheet to track inquires/sales all over the world. Each inquiry gets its own line and we enter in this line also country from where demand came from. Curenty we use this sheet only internal- only in company headquarter here in Slovenia. Today our exclusive distributor from Germany…
-
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
-
Report for files not modified in last 45 days?
Is it possible to create a report to list all files (sheets) in a folder not modified in the last 45 days? To be clear: I know how to run a report that shows the ROWS modified within the sheets. I want to know when the SHEETS themselves were last modified. Background: Currently I have a folder with hundred of sheets. They…
-
Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…
-
Alert(s) Updating a "Count" Sheet?
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
-
Reports and emails
From what I can see, reports do now allow formulas to be created within them (the formulas have to be in the sheets). I need to share lists of newly signed customers, recently created opportunities (pre-signed), recently cancelled customers, and customers we've decided not to take on along with the contract or potential…
-
Label Parent to Sub Tasks in Reports & Reminders
It would be helpful if Reports, Reminders and the current Outlook Beta displayed parent task descriptions when information is displayed for sub tasks. In our organization, many sub tasks could have similar descriptions in several phases of our projects. It would be beneifical to see the parent or outdented rows description…