-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Transferring everything within a workplace to a new Owner
Hello, As you can probably see from the title I would like to transfer everything within a workplace to a new owner. This includes templates, sheets, reports and dashboards, how would one go about doing this? Kind regards Anton
-
Percentage
Hello! I have a question, is it possible to create a percentage for symbols? I've been trying to create a percentage of items that are high priority, which would be displayed as a red flag. This would all be displayed in both sheets, reports and on my dashboard. Thanks for all the help in advance.
-
Resource View Possible?
I'm setting up a Sight/Dashboard for the team of engineers. I like how the Resource View shows each sheet someone is assigned to under their name, with a link to the sheet for more info. My goal is to incorporate that into the dashboard/sight view Is there a way I can achieve this for a without having to update it…
-
Sharing within a Workspace
I have some folders setup in a workspace. In the column 'Sharing' for the folders, it says 'Workspace'. In the 'Workspace Shared To:' list, it shows three users.. Somehow all users can see the items in the folder, not just the three users in the 'workspace shared to' list. How do I restrict these folders? Thanks!
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Enhancement Request: Sheet/Workspace Level References in Formulas
I would like to create notifications for the creation of new sheets in specific workspaces and in general better track what sheets are getting created where. To this point I would like to build a master sheet with drop downs for each workspace showing what folders and sheets are in them. A directory if you will. This would…
-
Multiple Project Task List Roll Up
Hello, Is there anyway to have a project task list that is updated from multiple project task list sheet? We are looking to have a master roll up of the Project Milestones without including all the tasks on 1 task list. Thank you
-
Finding a SmartSheet
I'm trying to find a SmartSheet, that I know exists, but isn't shared with me so I can ask the owner to share it. How do I find it?
-
folders inside workspace
Hello, I am new to the smartsheet community. I am trying to figure out how to show how many folders are inside a worksapce. My guess is it may not be possible.
