I'll do you one better. In going through another report just now, I realized that I previously made a similar reference successfully. Why I couldn't figure it out this time is anybody's guess.

Ah. The issue was using a period instead of a colon between {project} and {DE:Requester}. You actually used a colon the first time, which is what I thought it should be and had used in all of my attempts. Your second post corrected it. Thank you very much, again, Anthony.

Argh. ISEMPTY is a remnant from my FileMaker days. Thanks for catching that, Anthony. Unfortunately, replacing ISEMPTY with ISBLANK did not make any of the listed expressions work. So something is wrong with the project:Requester syntax.

Hi, I am trying to write an IF statement that enters either 1) the data from a task's custom field (Requester) or 2) the data from the same field on the project level. I can't find the syntax anywhere here or in the documentation. I have tried valueexpression=IF(ISEMPTY({DE:Requester}),{DE:project:...

Thanks again, Skye. It was driving me batty.

I was actually able to get it to work by mostly starting from scratch and simplifying the nested IF that determines the field to compare with the Actual Completion Date. But now that you mention only using CLEARTIME on the Actual Completion Date, I think that was the issue. Here is what works. val...

Hi Skye, Sorry, I had to let this go for the weekend and try to go at it with fresh eyes today. I was able to make the CLEARTIME syntax work on the calculation of the number of days between the Requested Due Date and the Actual Completion Date, but the calculation is still off in some circumstances...

So far so good! Seems to be working beautifully. Thanks again, Skye. Shawn

Thank you very much, Skye! Nice you meet you and the group, as well. I will give it a try.

Thank you. Is the time Noon-2pm PST? If so, I will only be able to make the first hour.