Reference field formula

Question

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})

skyehansen · Accepted Answer

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"?

kautuk_sahni · Answer

@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!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded