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?