-
Calculate % complete based upon start and end dates?
Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional "yearfrac" formula…
-
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
-
Webform vs Request Form
I really like the Webform feature. It's made things easier with coordination and data entry. Could I also upvote a feature for Request Form (as an extra step)? It would nice if the submitted Webform goes directly to the sheet administrator first to approve before it goes to a sheet directly. Not because it's been submitted…
-
Feature Request - History view
Ok, so it's nice to be able to see how things are trending, but given that things keep changing it means you need to have to keep old reports or backups around that you can plug into excel. Wait though, we have the history of each cell available within two clicks. And we have the highlight feature which shows which cells…
-
cc for update request
Hey SS folks, I would like to see the option to have a CC list for an update request. I work with remote teams that have onsite managers, and while I do most of the update requests to the team for corrections or omissions - the manager needs to have visibility of the update request so that they can keep the local team in…
-
View/Comment Only?
I'd like to allow people to view my sheet and comment on tasks without being able to make any other edits. It would be great to have more specific control of user permissions to make this possible. Maybe somebody has a creative way to do this with sharing/publishing?
-
Apply Format to individual words including hyperlinks
Hi, We really need to be able to format individual words with in a cell, instead of the format effecting the entire cell. For example: Here is some text within a cell and I want to highlight a particular word and NOT all the words in the cell. The same applies to adding a hyperlink to an external URL. Today it hyperlinks…
-
Consolidated Update Requests
When we first had access to Smartsheet, we were able to view all of our update requests on one screen. Did that go away or am I just missing it. Is there any other way to consolidate that information?
-
Enhancement Request: relative addressing for cell linking in sheets, reports and sights
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use Smartsheet for project management and have a set up a standard workspace which contains set of sheets/reports and sights…
-
Workspace Tabs
I've seen a lot of requests for more functionality around the tabs feature and I have a suggestion of my own. How about a "Workspace" tab that when clicked on offers a drop-down list of all of the sheets in the workspace? I'm thinking the tab bar could be a mix of "Sheet" tabs and "Workspace" tabs. Second suggestion, it…
