-
User Group use case?
I understand setting up and using User Groups makes it easier for sharing... but are you not able to "@" a group in conversations? Ive tried it in a few cases and nothing comes up. Considering the amount of manual work to setup and maintain groups, i feel it is severly limited use case if only for sharing, no?
-
Can Bridge Access Smartsheet Contact Groups?
I am trying to update contact drop downs based on who is in a Contact Group. Can bridge access Smartsheet Contact Groups?
-
Get Month and Year and Group/Sort
I've got a sheet in which sales reps input their daily activity. This sheet has a date column that is required. I'm trying to make a dashboard to track month to month levels of activity. Perhaps I'm missing something but there doesn't seem an obvious way to do this. I've tried making a report to group by month and sorts…
-
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,…