Will, this is awesome. Thanks for sharing, I didn't fully appreciate the extent that these validation rules could go to until your post!

Really excited about this functionality, sooo many times I've been asked if we can put validation on custom fields.   Here's a use case i think would be good   Use Case: We need to prevent people entering special characters into a text field as the field is integrated with a system (AEM Assets) that...

Hi,   Assuming that the date field is being captured on a project custom form (as your text mode suggests), you shouldn't need to use text mode at all. The Project object and it's data attributes are all available natively from a Document report. In the report builder, simply add a column and search...

Hi Kaylee,   It's not possible to selectively restrict certain statuses to certain users. The only functionality you have available is to customise the statuses that are available to different groups, however the entire list of statuses available to the group associated with your project will also b...

Hi, I would try using a REPLACE expression within your formula and replace "." with nothing (i.e., "")?  Best Regards,Rich. 

Hi Paul,   I'm afraid that this isn't possible to achieve natively within Workfront. Conditional formatting doesn't work on value expressions, nor does it work with collections i.e., nested(tasks).lists   Conditional formatting can only be applied to a singular value that is stored in Workfront's da...

Ahh ok, you could change the filter to be Document Version>>Proof Decision Equals "pending". That should do the trick. To demonstrate   Here I am showing the documents tab of a project. It has two proofs: ABC1 - Which is approvedDEF2 - Which is pending a decision   If I only want to show proofs tha...

Hi,   Apologies, fat fingers on my part!  Updated filter rules as follows:   If complete means that the proof has been approved then you would use: Document Version>>Proof Decision Equals "Approved"   If you just want to see document versions where any decision was given, then you would use Document...

Hi,   Try using Document Version>>Proof Decision as a filter in your report.   How you are classifying a proof as "complete" will dictate how you built this filter. But as an example, if complete means that the proof has been approved then you would use: Document Version>>Proof Decision Equals "Appr...

Hi,   I would also check that the time of your project's planned start date is set to the start of your working day (if your project is set to schedule from start date), or the planned completion date time (if your project is set to schedule from completion) is set to the end of your working day.   ...