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.
Sum Duration but without Milestones + Lag
Is it possible to use a formula or some other function to Sum the duration of a project but not include time associated with lag or between a task being completed and its milestone? i.e I only want to sum tasks which have a duration but I have used indents to manage my project which creates durations including unallocated time between tasks.
I want to sum this so I can estimate hours which can be billed in a project. I can't bill for time when we're waiting for information to come back from other consultants so I want this to be excluded from the calculation.
Thanks in advance.