how long before custom fields are available for calculation

[KristenS_WF]

I'm playing around with some custom fields in our Sandbox Preview environment.  I created 4 custom fields in a project-based custom form.  I'm now attempting to create a calculated field that uses those 4 custom fields.  In the past, I know you had to save/close out of the form and reopen it before newer custom fields would show as available in the Calculation Editor.  I've done that several times now, and I've also refreshed my browser, but the fields do not appear.

Is this a problem with the new form builder?  With the test environment?  How long does it take for these fields to become available?

[KristenS_WF]

Well, I can manually add the fields to the editor; I just can't select them from the dropdown list.  I guess that's better than nothing.

[quarkmage]

Do you happen to be working on any custom field calculations that are date-based? Just curious. I continue to look for easy ways to calculate turn-around-times from existing reports, but calculating difference between dates seemed previously outside of workfront's capability, but i am not sure how accurate or current that information is.  Thanks.

[KristenS_WF]

Not currently.  But I do recall in the past having to create some custom calculated date fields that use the CLEARTIME function.  I was trying to do a conditional formatting comparison of dates in a report, and the timestamps kept screwing things up.  I needed calculated fields that cleared the timestamps in order to make the comparison work.

There are date/time functions you can use to calculate the differences between dates.  I believe they work both in calculated fields and in reports/views: https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/... 

[quarkmage]

Thank you @KristenS_WF for the information and taking your time to respond.  I appreciate the insight and the links and will check that out.