-
Check A Box When A Value On Another Sheet Changes
I have a sheet that is pulling data from a second sheet. What I want to happen is when the status changes to RECEIVING COMPLETE on the second sheet, it checks the box in the received into stock column. The problem is that once that status is updated to that value on the second sheet, it's moved onto an archive sheet that…
-
Workspaces taking up a section of my screen
Hi Smartsheet, Why does Workspaces take up a section of my screen? I'm not able to scroll all the way wide right when the Workspace panel is open. Thanks, Eric
-
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…