-
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?
-
Sub different projects & Sync information possible?
Is it possible for smart sheet to allow to manage multiple sub projects within a master project? Each of these sub projects will be updating the tasks and data separately but it should allow to get synced on to this master project whenever change happens and visible to all. Are there any restrictions?
-
Planned Dates appear on days defined as non-working days in Smartsheet
We have defined holidays and non-working days in the Project Settings, but noticed that Smartsheet still shows several "Planned" Dates falling on these non-working days based on planned durations, instead of pushing these out to the next working day (This also happens for Saturdays and Sundays while we have defined M-F…
-
How to use multiple if not or statements
I am receiving an "invalid data type" result when I run this: =IF(NOT(ISBLANK([Start Date]@row)), NETWORKDAYS([Due Date]@row, IF([Date Completed]@row <> "", [Date Completed]@row, TODAY()))) and there is a null value for Due date. How can I add OR statement to this so that if either Start Date OR Due date are (not) blank…
