-
Automatic Linear Percentage Complete Formula
Hello, I am wondering if you can help. I currently use Smartsheet for project planning. I would like to build an automatic percentage complete formula. This formula should work off a linear progression line from Actual Start Date to Baseline Finish Date and the duration. So an example of a task would be: Actual Start: Now…
-
Smartsheet count function
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?
-
Is there a way to pull the baseline start & end dates from a project sheet?
I am creating a project status dashboard that will encompass all of our projects. It's simple enough to link each line to a project but the thing I want to be able to grab is the baseline start and end dates from the project. Short of scanning a column and finding the lowest and highest numbers, is there a way to access…
-
SPI and PLnned Value % in Smartsheet
Hi Everyone, I'm dealing with implementing Earned Value Management in our Project Portfolio as stated in PMI PMBOK guide.. However, I am not sure yet in how to calculate the % of Completion Planned for the whoe project as well for each activity since the new functionality of baseline in projects calculates for each…
-
Is there a way to identify and highlight that a particular contact has overlapping dates?
Staff assignment sheet I want to be able to highlight rows that have the same person assigned to overlapping dates. Assignment is a Contact list dropdown and the dates is a Date column.
-
Counting distinct values with two conditions
I am trying to count distinct items that fit two conditions, but I'm getting back an error. Here is the formula I was trying: =COUNT(DISTINCT(COLLECT({My Sheet Range 1}, {My Sheet Range 2}, CONTAINS("SEA", @cell), ({My Sheet Range 3}, CONTAINS("In Progress", @cell))))) If I remove the second condition or use only the…
-
Summarizing Text from Children
I have a hierarchy set up and want the parent line to automatically pick up all text in the same column as the children, ideally unique/distinct values only. For example, my children are "SEA Singapore" "SEA Vietnam" "Indonesia SEA" Thailand Which are all items selected from a drop-down menu I want the formula to return…
-
Roll-up report with dynamic view?
I have a situation in which I’m going to have a team of people, each assigned a group of sheets/projects, and more sheets/projects will be added regularly. I need to be able to: a. Aggregate data from each person’s sheets so they and their managers can monitor progress; and b. Give the team a user-friendly way to keep the…
-
Formula to return 'TBA' if cell contains text 'TBA'
Hi, I'm currently using this formula which works: =IF([\[H\] Variance (%)]@row < 0, "Under Budget", IF([\[H\] Variance (%)]@row = 0, "On Budget", IF(AND([\[H\] Variance (%)]@row > 0, [\[H\] Variance (%)]@row < 0.15), "Moderate Budget Overrun", IF([\[H\] Variance (%)]@row > 0.15, "Significant Budget Overrun")))) However, I…
-
Can we bulk export sheets to PDF that are part of a report?
This question stems from a previous topic. Given a report that pulls from 10 sheets (updated by different PM), can I bulk export all sheets to PDF so I can drop them in a Box folder for archiving with a weekly report summary?
