-
Issue with Future Dates and Global Time Zones
Hello Community, Looking for some help today to figure out how to correct time zone differences with dates. I have set up an Automation workflow to remove future dates in schedules and send notifications to the PMs. This would prevent future dates being collected in reports and dashboards. The settings for the Owner…
-
Copy of PMO suite
Hello I am new to Smartsheets! I have my PMO suite and when I made it I made a copy of it incase i broke something. I broke my metadata sheet and lost all the formulas. I did figure out how to put them in but there a ALOT of sections to fix. My question is can I just copy my copy of my meta data sheet into my old folder…
-
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
-
Workflow Update Notification Emails Not Highlighting the Updated Cell in Yellow
So, I am trying to set up a fairly comprehensive notification to my colleagues, when specific data regarding their assigned events change. I selected as many of the changes as I was allowed (19 appears to be the max). And while the automation seems to work, it isn't highlighting the cell that was changed in yellow. Which…
-
Absolute Sheet References for use in formulas across multiple sheets
We use our own variation of the Project Management Template Set, and our PMs copy the folder when they are initiating a new project. We would like to include a formula in the project plan template for which the reference to another sheet will persist and work in the copy. This will help so that the PM doesn't have to…
-
Identify who added a particular user to a particular group
We would like to get some info regarding audit visibility for group management in Smartsheet. We are currently unable to determine who added a user to the group. We check the Admin Center, but could not find any information. Could you please let us know if there is a way to: Identify who added a user to a particular group,…
-
Why is my Level Code formula erroring on just level 2?
I'm trying to produce a WBS. I used the helper columns and formulas from the Smartsheet template set. The Level Code formula works on all but the 2nd level (purple) which shows #NO MATCH. Expectation: First purple line should read 1 and second purple line should read 2. WBS works fine if I hardcode those values. Anyone…
-
Merged: Ability to Group or Organize Workspaces (by Client, Portfolio)
This discussion has been merged.
-
Scenario Planning is generally available!
The new Scenario Planning feature is generally available. This powerful feature is designed for project managers, resource managers, and team leads who are close to delivery and need a dedicated space to run what-if scenarios without impacting their live plans. Scenario Planning solves the key pain of operating under…
-
Enhance Row Collapse Functionality for Improved Project Management
Our team manages a large number of projects on a single Smartsheet, with each project containing multiple child rows to track weekly progress and phases. This results in an extremely long sheet, making it challenging to navigate and manage efficiently. Our management prefers to have all projects and phases listed on one…