-
Formula help on RYG Balls for Baseline Variance
hello all I'm struggling with this because the variance is in Days. I did a basic IF statement where: if the Status = complete then Green, and "nested if" if the Variance was < -5 then Red else Yellow. It just turned complete things Green and everything else yellow, because the variance is in Days (eg. 1d or -2d not a read…
-
One template with scroll down options for different timings of tasks
Dears, As we know making formulas in duration time is not possible, so I'm looking for other option to make life easy in below scenario: We have several production plants, producing different product types and using different packaging pritnters which has influence on overall project timing for new product introduciton. I…
-
More than one Baseline + Comments
Dear all, To enhance Smartsheet as a comprehensive PM Application, my company and I find that a crucial feature, baseline management, currently needs to be added. While the ability to set baselines is valuable, the limitation of only being able to set one baseline is a constraint. We propose the implementation of a feature…
-
Data Mesh doesn't allow start and end dates when predecessors are enabled
If the project aims to transfer data from one sheet to another, automation could be a viable solution. However, there is a requirement that both sheets must be identical in order to facilitate the data transfer. At present, there is no available option for field attribute mapping, which would allow us to perform mapping…
-
Merged: Baseline Project Tasks
This discussion has been merged.
-
Baselines for newly added tasks?
Hi, Is there a way to use the baseline function for any task that is added to the sheet AFTER the baselines have already been added. For example, the original timeline was 10 rows of tasks. We have 5 new tasks to enter into the timeline. The only option is to "Reset" the baselines, which I do not want to do since the data…
-
Adding New Task After Setting Baseline
Smartsheet Community: Once The Baseline is Set. It Would Be Nice to Have The Ability to Add New Tasks and for those Tasks to be Added to The Baseline without Re-Setting it. Today, I have to Manual Change All the Dates. This Drastically Increase human Errors and is Very Time Consuming.
-
IFERROR and MATCH Formula not pulling in formation - Prodactive S-Curve
hello, i came across a Video by Prodactive about S-Curves in smartsheet and so far everything has been working exactly as expected with one major exception; the "Actual" baseline. From the video and the downloaded examples, i used the exact same formula and referenced my sheet name versus what he had in his example. But…
-
Target Date vs Baseline in Project Management Office template
The project plan in PMO template have Target Start Date and Target End Date which seem to serve the same purpose as the Baseline Start and Baseline Finish. Are they redundant or am i missing something?
-
Baseline Varianz Meilensteine
Hallo zusammen, hat jemand eine Idee warum mir Meilensteine (Dauer 0) je nach Platzierung innerhalb einer Projektphase (Ende oder irgendwo; jedoch NICHT am Rand der Phase) mit unterschiedlichen Varianzen zur Baseline (1T/0) angegeben werden obwohl Datumsangaben Ende/Baseline-Ende jeweils gleich lauten? → Beispiel in Phase…
