I've been working on this for some time and just can't seem to get it to work the way I need it to. I am attempting to build one sheet that will allow me to track the status of all the projects in my …
Hello We are using smartsheet more and more in the organization. Happily :) But as the number of users grows, so does the number of sheets, etc. A sound governance document is needed. I'm now digging …
I need to add another scenario to one of y formulas, If one of the departments does not have to approve a certain type of change, they will choose N/A from the drop-down. So I will need the Approval S…
Hi, I'm trying to have a formula autofill as new rows are entered into a project list sheet. I know smartsheet has an autofill formula feature, but I'm not sure how to use it. Is it an automatic thing…
I'm using a Form to collect data that is populated in Smartsheet, and the form asks each user to include an attachment with their submission. I'd like to be able to mandate that the form cannot be sub…
Instead of an even roll-up - can the parent percentage be set to a specific value relative to the project - see my example below; 1. (Project) Big Steel Project - 100% 2. (Parant)Steel Box - 50% 3. (C…
I have read a few posts regarding the inability of the tool to automatically update duration based on changing % allocation of a resource i.e. Task A will be completed with 1 day duration by Resource …
Hello All, I am now responsible for reporting on the progress of multiple projects in our organisation and what is going on. I have created Sights for each that roll up into an overall position to sav…
Hi, I'm trying to create a Project management Dashboard but for some reason, when I click on "add a widget", I don't see the option to add a Sheet Data. Does anyone know why and how I can do this? THa…
