-
How to calculate % Planned in Father Rows?
Hi Community I created a new column to calculate the planned percentage in my project; however, in the father rows is not calculating correctly, even if I tied the percentage between complete and Planned, the percentage is not the same. I am using the following formula =IFERROR(IF(Finalizar@row = Inicio@row , IF(TODAY() >=…
-
Change Order Management
Does anyone have best practices for collecting and managing Change Order requests for Project Plans please?
-
Restrict Who Can Delete Sheets or create Verification Check before deletion
I recently had an unlicensed user with Admin permissions delete several sheets that I own. I was able to recover them since they fell into my deleted folder. Can this be restricted to only the owner can delete a sheet (I thought this is how it used to work?) Or can there be a notification set up to the sheet owner if…
-
Merged: Automation to Post a Comment
This discussion has been merged.
-
Does anyone use a Change Management Form in project work and have a dashboard?
Hello. Our PMO is beginning to use smartsheet as our primary tool. We're starting with basics and have created a project plan template that also rolls up into a dashboard. We would also like to track change requests and have an overview for reasons, # of requests, # of date changes made due to requests, etc. Do any of you…
-
Pulling Original Due Dates from updated Due Dates Cell
I am wanting to track, months into a project, where I originally had set the Due Dates. I have 300+ line items and I would prefer not to go in manually to update a new column with "Original Due Date". Is there a formula to pull that information from cell history so I don't have to manually do this? I sincerely appreciate…
-
Comments for Conditional Formatting
When creating conditional formatting, it would be helpful to have a Comments field where you could add context on what the formatting is indicating, and why it is doing it. This is helpful when you have multiple people that manage the conditional formatting. See the attached photo for a mock-up of this idea.
-
Dropdown Link is not working for me.
I am testing on this dropdown link but it is not working for me. 😣 I created both the source and destination sheet. Source sheet: text number or dropdown list column Destination sheet: dropdown list column After linking the dropdown list from destination sheet to the source sheet, the data is not showing in my destination…
-
FolderResources.GetFolderChildren isn't returning the createdAt and modifiedAt for sheets
The new version of the api (FolderResources.GetFolderChildren) isn't returning correctly the createdAt and modifiedAt fields for sheets. As an examplle the following call isn't returing the fields correctly : SmartsheetClient.FolderResources.GetFolderChildren(9999, null, null, null, null, null, null); Can someone raise…
-
Quick Fill to Multiple Cells?
Is there an easy way to quickly drag down the same cell values to 1,000+ cells? Important: I have the sheet filtered, as I only want this to be copied to specific rows. I have over 1,300 rows on the sheet, so I can't just use the column formula functionality. I was hoping I could just double click the bottom right corner…