Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
SOLVED

Reference field formula

Avatar

Level 1

I can't figure out how to copy a formula we use for a reference number into a different custom field. When I copy and update the custom names it tells me that "Packaging Request Type is not a valid field in your system".  I'm not sure what that means? It's a custom field we have been using and looks the same as Tactic Type from the current formula.

Current formula:

CONCAT(LEFT({DE:Tactic Type},2),"_",IF(MONTH({DE:Final Files Due Date})>=8,RIGHT(YEAR({DE:Final Files Due Date}),2)+1,RIGHT(YEAR({DE:Final Files Due Date}),2)),"_",{referenceNumber})
 
Copied Formula:

CONCAT(LEFT({DE:Packing Request Type},2),"_",IF(MONTH({DE:Final Files Due to SUPPLIER})>=8,RIGHT(YEAR({DE:Final Files Due to SUPPLIER}),2)+1,RIGHT(YEAR({DE:Final Files Due to SUPPLIER}),2)),"_",{referenceNumber})

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I always click on the field (separate window), and copy the field name from there and then paste into the calculation, if I'm having issues. That said, are you aware your copied formula says "packing request type" and that your error message says "packaging request type"?

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

I always click on the field (separate window), and copy the field name from there and then paste into the calculation, if I'm having issues. That said, are you aware your copied formula says "packing request type" and that your error message says "packaging request type"?

Avatar

Administrator

@RebeccaJo1 Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!



Kautuk Sahni