From a TASK report, if I filter for task name contains RFX, status is Complete, and actual completion date in the past 2 weeks, here's the code I get: name=RFXname_Mod=cicontainsstatus=CPLstatus_Mod=inactualCompletionDate=$$TODAYactualCompletionDate_Mod=betweenactualCompletionDate_Range=$$TODAY-2w  ...

The calculated data expressions page has a list of functions you can try -- I'm wondering if maybe you have tried CLEARTIME. https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions   If your custom field is just a date field and...

That's correct. Be sure you leave feedback on the feedback button.

is it possible you have a task approval attached to that task?

I heard that they have to be layered into the same business rule. Which kind of makes sense.

In my mind, you need to account for all possible combinations of blank vs not-blank. As an example, consider 3 fields: * all 3 could be blank * all 3 could be filled out * any one of the fields could be filled out * any 2 fields could be filled out   So (again, my opinion) a calculation would need t...

You should be able to use something like this: linkedname=projectnamekey=view.relatedcolumnnamekeyargkey.0=projectnamekeyargkey.1=convertedOpTaskNamequerysort=project:convertedOpTaskNamevaluefield=DE:project:convertedOpTask:YourNotesFieldNamevalueformat=HTML

that's just how it works. If you want to see it in a chart, it would need to be a calculated field on the object. If it's only in text mode on the report, it won't transfer through to a chart.

I think this is still all that's available: https://experienceleaguecommunities.adobe.com/t5/workfront-questions/defined-schedule-in-the-system/m-p/691543#M62342

you could potentially just get away with doing something like this?   linkedname=directvalueexpression=IF(CONTAINS(".",{DE:YourFieldNameHere}),"",{DE:YourFieldNameHere})valueformat=customNumberAsString   (in other words, if the field name has a period in it, don't display it)