-
Best practices and Governance
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 into the subject and I'm wandering whether someone went through this exercise before me and would be ready to share its…
-
Formula to Ignore a N/A if selected from a dropdown, and not break the rest of the formula
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 Status column to IGNORE the N/A in that row. So if only 3 people needed to approve it choosing then the non approvers choose…
-
How do I autofill a formula to new rows that will be added via a web form?
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 by default, because if that's so, my formulas from the rows above are not autofilling in new rows created. Any help…
-
Creating an Alert for Attachments
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 submitted without an attachment OR set up an auto-notification to the user submitting the form to submit an attachment if that…
-
Weighted Percentage for Parent Rows
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. (Child) Bottom 70% 4. (Child) Sides 30% 5. (Parant)Steel Post - 30% 6. (Child)Short Posts 20% 7. (Child)Long Posts 80% 8.…
-
% allocation
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 X. I change Resource X to 50% allocation and the duration should automatically be updated to 2 days. The last post I read…
-
Cell Change Counting
Hello, Is there a formula that will count the number of times a cell changes? Thanks, Rozan
-
Monthly Management of Projects
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 save time and effort. However, I would like to create a task list for myself to make sure that i have covered all bases on…
-
Trying to add a Sheet Data widget to a sight
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? THanks! Carine
-
hide certain columns per user
Basically: I want to hide certain columns for specific users. In detail: I have 7 users shared to an affiliate sheet. This sheet contains the assets needed for marketing as well as rev share and money exchange. I want my graphic team to update the status of graphic assets but I don't want them to see the rev share columns.…