-
Reference Entire Sheet AND Filter Rows Where Column Value ="Search Value"
I am simply trying to do the following: - Refer to another sheet (ALL ROWS and COLUMNS) with the following conditions: - Where in Column [STATUS] is = "Done" The RESULT should be: - This new sheet shows all rows and columns from another sheet where Status is Done.
-
Users and Accessing Sheets, etc.
Hi - thanks for reading this. I'm trying to find some files and asked for access. Was told to search the backend of Smartsheet. (IS there a "backend" of Smartsheet?) I'm not a system admin. I think that means I can't see anything not in my workspace. Is that correct? If you're not shared on sheets, can you see all sheets…
-
Transfer data from one sheet to another
I know SS has the "move to another sheet" or "copy to another sheet" but sadly it does not look like you can do that and have "cell links" from the blank form that you are going to copy data to , to do other items. Does anyone do any copy / pasting that is advanced and would have some suggestions? Here is what I am doing…
-
Moving All Collaborators to New Workspace
We would like to reorganize our workspaces, combining 5 difference space under one umbrella workspace. However, how can we take our existing collaborators and their current permissions to that new umbrella space. Do we have to re-enter them all or is there a way to move them? (See example below, want to move Workspaces…
-
Is there a way to easily/quickly hyperlink 100's of sheets.
I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individual sheet. I understand that the desired effect can be obtained by running a report…
-
Sheets vs Workspace
Hi all, I am just not sure how the files are going to behave after I move them to the workspace from sheets. In the attached picture I have created a sheet name rush request from customers where I've reports, dashboard, and a sheet. The sheet has a form attached to it. To share do I have to move everything to the related…
-
Identifying Workspace Ownership
Is there a report that can be ran to show the workspaces in our account and who owns them?
-
It there a formula to use so that I can calculate an amount between dates?
Hi! I am trying to calculate the amount outstanding between certain dates, but I can't figure out what to use or if that is even possible.
-
Hide Workspaces that aren't used often
Hello, As our company admin for Smartsheet, I typically deploy all-new Project Workspaces - this provides me with the opportunity to assist team members if they become stuck or have an issue; I can then problem-solve with them within their work-space. This leads to an issue where I have many Workspaces visible, of which I…
-
How can I share a report to an user without sharing him paper, source of report?
I would share some data in a report with an user but I do not want share with him the paper, source of report. The aim is to use report as a tool able to visualize data for all users and to track and modify data on a paper used only by our project managers. Thank's you
