Workfront Planning Formula Field

Question

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 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded