Workfront Planning Formula Field | Community
Skip to main content
Z
ZakCo
New Member
April 25, 2025
Question

Workfront Planning Formula Field

  • April 25, 2025
  • 2 replies
  • 400 views

I am working on a formula field in Workfront Planning. I have a connected field for {Deliverable Type} that houses a list of deliverables in a separate record type in Planning. When a certain {Deliverable Type} is selected from the available list and a Qty is input in another column I want the formula field to tell me the resource hours needed to complete that amount of deliverables.

 

The formula I'm using is:

IF({Deliverable Type}="Video", CONCAT("Video Producer: ", {Qty} * 15, " hrs; Video Editor: ", {Qty} * 10, " hrs"), "")
 
Workfront Planning is recognizing this as a valid formula but it's not returning anything after I click save. What does work is if I were to switch {Deliverable Type} to a free text field and type in Video.
 
Any thoughts on how to solution for this? Does Workfront Planning even support this sort of formula?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

M
Adobe Employee
monicacardosoAdobe Employee
Adobe Employee
May 8, 2025

Hi @zakco, 

 

Thank you for your question! You mentioned that "When a certain {Deliverable Type} is selected from the available list"; I am wondering is the original "Deliverable Type" a multi-select field? 

 

If so, those are not supported in formulas. You can view this information in our documentation HERE. If not, I would recommend submitting a ticket to the Workfront Support team so that we can look into this further with you. 

 

- Monica 

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    August 29, 2025

    @zakco 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 benefit the community. Thanks again for being part of the conversation!

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...