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.

I am trying to see if there is a way to limit which types of tasks display on a users timesheet.  I'm trying to see if there's a way to only show tasks on a timesheet that contain a key word, such as "Time".   I wondering if Timesheets has a similar functionality for creating filters similar to repo...

Hi All,   Running into a bit of an issue creating either a proof approval, or document report that only captures items associated with the project.  The plan is to attach this report to the project left panel to show users the status of proofs associated with this project.  I've been able to do this...