-
Workspace Sharing Alert/Notification
Hello all - I'm looking to see if anyone has figured out a way to be alerted when sharing permissions change at a Workspace level? I know there's a template automation for sheet level sharing permission changes but having a sheet in a workspace with that setup then having the Workspace permissions change doesn't trigger…
-
How do you move a sheet from one workspace to another?
Assume both Workspaces are owned by the same person. Thank you!
-
How can i sort the workspace folders/reports
Hi, i've been trying to sort in alphabetical order of my reports in the workspace, it's not working so i tried to rename it by using numbers infront of the name still it's not working please help
-
New user cannot edit report filters even with Admin permissions
Hello, I have a new employee and have setup her Smartsheet account just as we do with all new employees. I gave her a license and added her to a few user groups to give her access to workspaces and "Editor - can share" permissions. She is unable to edit the filters of some commonly used reports. I verified she has…
-
Can I create a form that can automatically update a worksheet.
Hi there! I’m sorry, but I’m very new to this platform and still trying to understand how it works. My employer has assigned me a task to improve the use and functionality of our worksheets. He suggested that I explore the possibility of creating a generic form that can automatically populate client worksheets. The…
-
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 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…