-
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.
-
Report Grouping Work Around
I have a list of SOPs and their supporting documents (Forms, Logs etc). As you can see in the Excel example, we have the SOPs in Green and the supported docs below. Some, like the SOP Training/Retraining Record, are used for multiple SOPs. I tried: Using Gantt functions, added a Predecessor Column but I couldn't run a…
-
Report / Dashboard - Grouping option not working
I added a grouping in a report to organize the display in a dashboard. I want to group the report by type of project and for each type of project sort by go live date. When I am in the report, the grouping works. However when I pull the report in a dashboard, the grouping is not taken into account, only the sort by go live…