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: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})
Solved! Go to Solution.
Views
Replies
Total Likes
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"?
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"?
@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!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies