-
Removing Duplicates while also adding together values from other columns
I have a bit of a complex situation. My company uses SAP for purchasing and we pull an open order report weekly to keep track of each of the buyers orders and delivery dates. I've recently set up a Data Shuttle so we can transition from manually editing the report in Excel to a more fully automated report in Smartsheet.…
-
Nesting DISTINCT into an AVERAGEIF formula
Is it possible to use the DISTINCT function within the AVERAGEIF function? I need to average the number of days a PO has been on order if a specific purchase group number was used to create the order. The problem is that our data is pulled from SAP, which displays the POs line by line, meaning that there are multiple rows…
-
Create templates WITHIN an existing workspace
Hi, We need the ability to create and use a template set within an existing workspace, without it creating a separate workspace. Steps: Create> browse templates> create from template but IN an already existing workspace without creating a workspace labelled with the template name.
-
Workspace Shared to panel
Hello, Would it be possible to reduce or even hide the panel showing who is shared to a Workspace? I'd like to see the names of the content within the workspace far more than who the Workspace is shared to. If the Workspace Shared to section could be minimized, that would be ideal. Thank you for your consideration, Lisa
-
workspace activity log
view changes that are being made in a workspace, like track new sheets made, who made them at what time, deleted sheets and dashboards, etc. short story behind the idea: a colleague wants to know if there is a way to notify others/themselves if a new sheets were made/added. If only we can make a sheet dedicated to show all…
-
Why is there a mismatch in the ownership of a dashboard and the workspace it is in?
Hi! I am the owner of both the dashboard and the workspace but the dashboard shows me as an admin of the workspace. Does anyone know why this is happening? I dont think its causing any issues I am just confused.
-
How to automatically have a report update when a new sheet is created in a workspace
Hello! I am trying to create an ongoing report/ chart with a workspace. So that anytime a new sheet is added to the workspace, it automatically updates the report, therefore updating the chart on the dashboard. I thought I had it figured out, but then one of our employees added a sheet to her workspace (outside of any…
-
System Admin or another role for Ability to View/Report on All Workspaces
Smartsheet needs a critical feature enhancement to align with industry-standard SaaS practices: grant System Administrators inherent visibility into and access to all workspaces within the organization. Currently, admins are severely limited in their ability to oversee and manage workspaces, relying entirely on individual…
-
Dashboard Help- COUNTIFS, Checkboxes and Hierarchy
I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is measuring by Parent/child hierarchy with the formula =COUNT(ANCESTORS()) + 1 Thanks!
-
Sync Automation Edits Across Multiple Sheets
I have a workspace that I use for all cross functional teams, internally and externally, for all active projects. Each active project has it's own project specific sheet. If I edit an automation on one sheet, there is no way to copy that same edit to another sheet without copying the entire sheet and starting over. Ex:…