Using Fusion to update a field in Workfront Planning does not trigger a calculated value based on that field

Question

Hi, this might be a trivial question, but I am unable to get it to work.

I have a calculated field that should update its value whenever a second field (status) is updated. I want to use Fusion to update the status, and I am able to make that update, but it seems the formula of the calculated field is not triggered with this update.

Is there a way to actually update the status field through Fusion, and trigger the calculated field to be updated as well?

Thanks in advance for any help.

Joao

JoaoMota · Accepted Answer

I wonder the way you ordered the conditions may make a combination fall through the cracks.

I've tried to "clean it up" - if that doesn't work still, then I'd take ONE record, the one you see working when making a change manually, and put that specific record in Fusion (ie change its status) and read it after modifying it.
If that is not working it's time for a ticket, probably.

IF(
    {Status}="Backlog",
    IF(ISBLANK({Sprint Schedule}), 
        CONCAT("Backlog | ", {Tactic Name}),
        CONCAT({Sprint Schedule}, " | Backlog | ", {Tactic Name})
    ),
    IF(!ISBLANK({Sprint Schedule}),
        IF({Status}="Planned",
            CONCAT({Sprint Schedule}, " | In sprint - not started | ", {Tactic Name}),
            CONCAT({Sprint Schedule}, " | ", {Status}, " | ", {Tactic Name})
        ),
        CONCAT({Status}, " | ", {Tactic Name})
    )
)

I tried with that cleaned up formula, as well as with a specific record, but still couldn't get the formula to kick in.

Will open a ticket for this.

Thank you for your help, really appreciated it!

Sven-iX · Answer

Check your calculated field first: does it work when you manually update the status?  If it does, you can force a recalc of the custom fields. See the Fusion module MiscActions

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded