Good afternoon.
I have a question about the percentage during the project, because my% predicted on the date and my% Complete, does not hit when they are the same.
I think your formula aide is hiding part of the answer.
There are a couple of different factors at play here.
1. [% Complete] children are entered manually. Unless your manual entries match the predicted, they will diverge.
2. If you check rows that are supposed to finish today, since you use greater than instead of greater than or equal to, you may get odd results because the End Date for today is (probably) at the end of the work day, which may or may not line up with the value returned by TODAY()
3. [% Complete] roll up is based on the sum of the individual durations and your prediction is based on the start and end dates. If there are any gaps or overlaps, the two numbers will diverge.
There's more, but should get you started.
Craig
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…
