-
Finding a value from one sheet on another sheet and transferring cell info onto both
I need help figuring out a formula that will cross reference between two sheets. I have one sheet that stores our open orders and another that tracks our orders undergoing quality assurance. What I need is a formula that takes the order number from the open order sheet and searches for it on the quality assurance sheet,…
-
Can I publish a workspace?
I know how to publish each sheet within the workspace, but is there a way to publish the entire workspace so that a group of people can view it but not make edits. The only thing I can find is share but the people who need to view is ever changing.
-
Disable Sharing of Workspaces via Security & Controls
We have had instances of team members sharing entire Workspaces in lieu of Sheets to external parties. This poses a risk of non-company personnel viewing aspects of a Workspace that they shouldn't. We typically grant all company team-members Admin rights due to the limitations of Editors (not being able to create new…
-
Import Excel Workbook as Workspace or Folder
Currently, the import function only allows importing one sheet at a time. An easy solution to accommodate workbooks with multiple sheets is to allow them to be imported as a new workspaces or folders, with 1:1 sheets.
-
Reorganizing the order things appear in Workspaces
It would be really helpful if we could reorganize the sheets, reports, and dashboards in Workspace. Currently it is set up alphabetically, which is really messy for my purposes, and I would love to be able to move my guide dashboard to the top, even though its name is not alphabetically first.
-
Add Hyphen Checkbox schema to help with tracing a sheet to its location within a Workspace/Folder
When a user clicks on the "Sheet" button in a report to find where the source sheet(s) is found it is extremely hard to locate which workspace/folder the sheet is located within. It would be extremely helpful to use the UI design Smartsheet already uses when less then all items within a folder are selected; a hyphen in the…
-
Merged: Automated Deleting of Old Data
This discussion has been merged.
-
API - "Get Workspace folders" Method Results Not Matching Documentation
I'm making the call with the parameters matching the documentation and not getting the same results. I'm only getting "id", "name" and "permalink" for each folder. The "Responses" in the documentation includes an array with reports, sheets, sights and templates, as well as details for each of those objects. Am I doing…
-
Consolodating rows with the same primary column
My company is looking to replace an Excel spreadsheet that we use to record the results of an order report in SAP. The problem we have is that SAP populates each order by the lines on that order. So for example; if an order has 8 lines on it, it lists that order 8 times with the quantity of each line rather than showing…
