This is a question and a requests depends In our company we want to use columns to track time in this format 9:15 or 10:45 .....etc and the formats doesnt include time. I see the announcment saying time in mins .....etc however maybe this is in Gantt enabled where there are two dates.... we just want to have time format…
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 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…
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…
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…
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…
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?
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…
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?
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…
