the custom fields I'm trying to extract from the expense form are dropdowns and text fields (five of them to be exact). The issue I keep running into is that expenses and task aren't in a hierarchy together, which is why I believe I'm not able to make the jump via text mode. Was hoping someone had ...
Is it possible to get a custom expense field (at the project level) to display on a task report? I've tried nesting it but I can't seem to figure how to get the data to jump to the task level/report. All feedback is greatly appreciated.
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 ?
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.