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

Regístrese

Social Login

Bienvenido

Social Login

Escaneando el archivo en busca de virus

Este archivo no se puede descargar