-
Linking directly to files from a dashboard?
I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files. Saving as images wont work either, as we have 10+ files to link to, and want to organize…
-
Column Highlight
is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.
-
Collaboration in Smartsheet (Saving)
Hello, I am just wondering what is the best way to work in collaboration on smartsheet. Currently when multiple users are working in the same sheet and one clicks save the other users data is lost! How do I prevent this from happening. What is the best way to guide the teams on how to work with each other effectively.…
-
Roll-up report with dynamic view?
I have a situation in which I’m going to have a team of people, each assigned a group of sheets/projects, and more sheets/projects will be added regularly. I need to be able to: a. Aggregate data from each person’s sheets so they and their managers can monitor progress; and b. Give the team a user-friendly way to keep the…
-
Project Planning: Percentage Complete from Dates
Hello I'm currently using Smartsheet for project planning. I want a forecasted percentage complete on progress to date from baseline start to baseline finish. Can anyone help please? Thanks in advance! :)
-
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…
