-
Speed up loading of a Report linked to multiple Sheets
I have a number of Workspaces representing different Projects. I want to be able to Report on specific Sheets within each Workspace. I have several different Reports, each uses data from a different Sheet within the Workspace(s). Whenever a new project (Workspace) is added, I amend the Report data source to include the new…
-
CountIf Date formula compare different date columns
I have 3 date columns: Start Date, Draft Due Date, Final Due Date The date columns are all initially auto-set to the same date; professionals are to subsequently update the Draft and Final due dates to a later date. I would like to count the ones that never get updated, i.e. Draft Due Date = Start Date. By the filters…
-
How to build a report that will count different criteria from a column?
I have a dropdown multi-select column in my sheet. It can be seen below: I want to be able to build a report in Smartsheet that will be able to tell me the count of each different category. For example, a count of all the clients that selected American/Alaskan Native as their race. Or, all the clients that selected…
-
Totals Per Month Using Multiple Columns
Hi Everyone! Hope you are all having a great day. I can't seem to figure out a formula to calculate values in a given month using multiple columns. More specifically, I'm trying to reference our main sheet and count values from columns called "Meeting 1", "Meeting 2", and "Meeting 3". I only want to count the meeting that…
-
Merged: Checkbox column SUM summary in Reports
This discussion has been merged.
-
Is there a way to auto-generate an MOM (Minutes Of The Meeting) type of sheet/report from your WBS?
I'd like to know if there's anyone here who has tried generating an MOM (minutes of the meeting) directly pulled from your WBS? The intention is for PMs to prevent doing duplicate work, one is updating their WBS, then another sheet or document type for their MOM. Appreciate anyone who can share their experience and best…
-
Approved Domain Sharing
Hi all, As an Admin I would like to run a report to establish what external users have been given access to our content. All external users have to be in the approved domain sharing list, however what are they accessing? Thanks Gavin
-
For a Report, Add option to have groups colapsed by default
For a Report, Add option to have groups colapsed by default or have a setting that would expnd and colapse the groups.
-
Resource Management Analytics - Conditional Logic
When creating a new report in Resource Management Analytics there is no conditional logic between the filtering options. It would be ideal that when Client A is selected, the relevant Projects to Client A are displayed, at the moment all projects are displayed for all clients. I need to include client name in the project…
-
Index/Match vertical Report
Hello, I have a form for people to submit dinner menus for themselves and for up to 11 guests (but there would be 12 children as the primary contact meal would be a child as well), plus drinks. This forms feed into a sheet that has 74 potential columns of information. As you can imagine, it is too large to really see…