-
Way to calculate parent row % Complete in other columns (like % Complete) for SPI.
We have a Planned Value column that is based on Start and End dates and a SPI column that is based on Planned Value and % Complete. Our Planned Value column is used to show what the task % Complete SHOULD be for the project where the % Complete is what the ACTUAL % Complete for the project is. The SPI uses %…
-
Rolling Negative Status Up Hierarchy from Children
Hello, I am working to streamline my project timelines for quicker daily tracking. I currently have a formula based on the task completion % and end date that gives a status and conditional formatting for the negative statuses: "At Risk" & "Late". It works great at the lowest level, but I am running into issues where I…
-
Do Not Email Notify Triggering User from Workflow Automation (PMO)
How can I stop my automations from copying the triggering user via email? The automation itself works great for letting the inteded person know they've had a task row assigned to them via email - but the triggering user does not want to be copied on said notification. I've searched the community for answers - I've been…
-
[Upcoming] Smartsheet Webinar for Project Managers, Marketers & Client Services
Working on multiple projects with tight deadlines, limited resources, or competing priorities? You’re not alone. In this upcoming webinar, we’re teaming up with Clear Digital to share how they manage 20+ projects at once with 50% more efficiency using Smartsheet. Register here! What to expect: Real-world examples of how…
-
Formula for counting how many times a cell has been updated
Is there a formula that you can suggest that will count the number of times a Date has been updated in a specific cell? For example; if I have a date of 4/1/2025 and I update it to 4/21/2025, I would expect to see "2" in a cell titled "Number of times date updated". Delays can happen for various reasons and I would like to…
-
COUNTIF & Multi-Selection Dropdown -- Count multiple entries
My data input sheet has several columns that are Multi-select dropdowns. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Example of options in the Multi-selection dropdown: * Apple * Pear * Grapes * Banana * Other I need guidance on how to structure the criteria for…
-
Central Location for User Comments across Smartsheet
My team uses a mix of sheets, reports, and WorkApps every day. Having ONE place to see all of my comments across Smartsheet would be extremely helpful to reference and track progress of my work.
-
Automation Workflow Asssistance - Trigger based off Task's due date
Hello, Is there a way to sent an automation reminder to be triggered on my project plan for a task when another task's due date is 3 weeks out. For example, I have task A, task B and task C. Task B and Task C need to be completed before Task A can be completed. I am wanting to create an automation to notify the assignee…
-
Project Status Formula Help
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column Hierarchy=0. The objective of the formula is as follows: If the Project Override field (in the Sheet Summary) is filled out…
-
Formula help within a Sheet
Hello - we are having problems adjusting a formula to include additional details. The formula is being used on a sheet for a project checklist. The parent formula shows the overall status of child tasks - if they are all "Completed" then the formula should say "Completed", if they all say "Not Started" then the formula…