Hi All,    I'm trying to figure out a way to create a custom field that lives at the parent task level that sums up a custom field that is associated with each child task of the parent.  I've been using the SUM function but I'm not sure how to reference the child tasks in the formula.  Any help is g...

Is there a way to track the duration of time a project has spent in the "On Hold" Status?  If its two separate formulas I know I can use a third WEEKDAYDIFF formula to calculate the duration, but I'm not sure how to get the time stamps of when the project went "On Hold" and when it came off of "On H...

Thanks for all your help with this Graham! I did have one last question regarding this formula. If you were trying to capture scores that fall between two variables, how would you capture that in this formula?  >1 but <4 ?

Thanks Jarrett!  Is your formula tied to a task/project status?  How would I go about tying it to a custom field?

Hi All,    I'm trying to create a calculated field on a document form that displays the following text when the number present falls into one of the following 3 ranges:   < 0 = "Late" =0 = "On Time" >0 = "Early" The field will pull the numerical data from another custom field on the form.

Thanks Rich!  this is exactly what I was looking for.

Hi All,   Does anyone know how to get a document thumbnail to display in a proof approval report?

Hi All,  I'm creating a proof review approvals report and I'm trying to get the project name that I got to display, to become a direct link to the project.   This is what I have so far:     displayname=Projectlink.value=textmode=truevaluefield=documentVersion:document:project:namevalueformat=HTML   ...

is there a way to create a link to the actual project in the column?  link.value=????

Thanks Rich!  Your feedback has helped a lot.