Workfront Planning Formula Field

[ZakCo]

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?

[monicacardoso]

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]

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