Automations not kicking off when cell updated from a report

HE245

I have projects with automations that update a target cell after a source cell has been updated. Specifically: if % Complete = 100%, set Status to Complete.

The automations work when I'm updating from within the project sheet.

But when I update % Complete from my master report that aggregates all my projects, then I notice that the Status doesn't update.

Should I not expect the automations to run if I'm not updating directly in the project sheet?

NicoLHC

@HE245 its a pleasure to meet you , can you share some screen shots.