Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
% Complete and Durations
I am a recent user of SmartSheet and was unable to find an answer in any of the current help venues. My apologies if this is duplicated elsewhere.
Here is the situation I am facing:
- I have a task with a two day duration. Let's say it was set to complete yesterday.
- Today, I am told that the task is only 50% completed
- Logically, this means that the task should complete today (50% complete of two days = one day completed. Two days duration means that I have one day of work left. Today, being a workday, is that day.)
- If I indicate that the task is only 50% completed, I would expect the Finish Date to change to today. It doesn't. Alternatively, if I change the Finish Date to today, it changes the Duration to 3 days which is inaccurate. The other side effect of this is that it also affects the Overall % Complete of the project since I've now effectively added one more day of work to the effort.
Any ideas on how to get around this? Ultimately I think this probably ties to the some of the Baseline/Actual threads but I'm a newbie on formulas and haven't figured out how to do those calcs yet.
Any help would be appreciated!