-
How to align column in when grouping reports
I am grouping a report on a given column (e.g. column A) and showing all rows under that group. However column for grouping is still shoing a width which i wish to get rid of. as shown in below or in attched document. Equipment xxxxxxxxxxxxxxx Part 1 xxxxxxxxxxxxxxx Part 2 I have used xxxxxxxxxxx to show spacing only here…
-
Sorting ascending order (monthly)
Hi, I'm having trouble organizing the column in ascending order. I'm trying to plot this into the dashboard and after Jan comes Oct as I'm trying to group them together. Before I tried not to put a number before the month that messed up the order more. Not sure how to fix it. Any input will be appreciated.
-
Report grouping by system generated date?
I'd like to create a report that groups entries by created date, without the timestamp. The entries come from a form, and adding a system generated 'created date' is more efficient. However the grouping function ends up splitting every entry separately because of the timestamps being different. Is there a way to group by…
-
Template with shortcut buttons for common operations
Hello, I want to create a template whereby I define a bunch of rows (for example, "bread," "fruit," "dairy") and some columns (eg "serving size," "calories," "price," "perishable"). I want the user of the template to add one or more rows nested one level under each food category, eg: "pita," "rolls," and "biscuits" as rows…
-
Gantt chart line for overarching group within a report
Hi All, I have report fed by a data sheet which contains dates for departmental events. These are grouped by department. I have added a Gantt chart which displays the individual lines but i'm wondering if it's possible to have the Gantt data roll up into the grouped Department line. For example, Department A has event 1 on…
-
Hierrarchy in web forms
I have data broken out by region (AMER, EMEA, & APAC), and there is budget information contained in each row. The region is a parent and the corresponding rows are children. This allows me to get a regional budget summary. Is there a way to maintain this hierarchy (parent/child relationship) when rows are created using web…
-
Grouping Rows
Hello, I have created a smartsheet update tracker, in the format shown in the screenshot below. The separate teams provide their updates in the nested row of the spreadsheet. There are also many formulas on the sheet. I would like to sort these rows from time to time so they can display in progress projects at the top,…
-
nested groups
Does Sheetsmart allow me to create hierarchical groups? In other words, can I add a group to a parent group? Google Workspace allows for nested groups. https://support.google.com/a/answer/167100?hl=en
-
Grouping
I have a tracker I started from a Project template which I am pulling information from into a Report and for some reason the column I want to group by does not appear as an option for grouping. What is the reason for this?
-
Count # of Parent Rows in a Sheet
What formula can I use that simply counts the number of parent rows in a single sheet? My scenario: Each parent row is a different customer. I want to know how many active customers a particular PM is working with and link that number to a metric widget on the PM's internal dashboard.
