Excellent this explains how to have them work together. Do you feed the fields from an excel doc or API or do you manually create and maintain all the categories and sub categories? Scott Hinchman Automatic Data Processing, Inc.

Hello All, I have a scenario where I need to classify Business Unit, Division, Sector, Segment There is a file I have in excel with every instance of the companies structure but its massive 521 scenarios of those four groups. So manually entering this into custom form drop down is out and I also don...

That would be a great solution but its already a well established form with many users. We would need to retrain them so we are trying to avoid that while also reduce the number of entries with missing data. Scott Hinchman Automatic Data Processing, Inc.

Hi Doug that makes sense and I like your idea at the end as well :) thank you for adding additional clarity I am happy to know I can do something that will solve for the problem. Scott Hinchman Automatic Data Processing, Inc.

I think I understand what you mean but I read the PowerPoint and I am not sure what I am puling from that as there is a lot there. This is likely due to my limited experience in using workfront as far as calculations go. When you say Calculated Custom Data parameters is that different than a calcula...

I have some complicated custom forms that have different scenarios and we are hiding whole section of the form unless its relevant to the scenario selected. But because we hide them it seems we cannot then make the field required because it won't allow them to submit the form due to the required fie...

I have found the approval flow reporting to be extremely poor in workfront and I am interested as well in better information. Right now I have been exporting information from Approvers and Status field. The results will show what I list as the description of the stage, the name of the people, and if...

Thank you both for your suggestions. I think I'm stuck with a CONCAT and trailing |||| for instances where there is no GL Code entered. As I would need it to show all the GL codes used in that forms submission. I was trying to rid myself of the | with the if statement so it would only return IF ther...

Hello All, I am trying to complete a formula where a calculation will only CONCAT fields if there is data to CONCAT. CONCAT(IF(custom field called Role 1 has data,CONCAT(Role 1 GL Code," | ",)," ", IF(custom field called Role 2 has data,CONCAT(Role 2 GL Code," | ",)," ", IF(custom field called Role ...

Yes please very important for our org as well.