Is there a way to see if an Automation was completed?

Options

Hello,

I am having trouble with an automation not running. It will run sometimes and other times it will not. I basically have it where if text is entered into cell 1 it will change the status cell to closed, once closed it will send an email to a different person letting them know if the ticket is closed. Currently when we enter in the "resolution" into cell 1 it will sometimes change the status cell and other times not. There are about 8 people working in this sheet as it is a ticket tracker and i don't know if that's the problem or if there is another issue.

Answers

  • Amanda Carta
    Options

    If they are working off of a Report made from the sheet then those formula's take time to calculate so I always save and refresh. I use reports so that they aren't in the main sheet with all the columns and it helps on data control. If they are working off of the sheet then I'd have to see the formula and how the notification is set up to be able to help more.

  • Jeremy Oesch
    Options

    Forgot to also ask is there a way to then check what automations are running or not running like a debug screen that shows what is happening on a per automation scale?

  • Jeremy Oesch
    Options

    @Amanda Carta

    They are working straight on the sheet not from a report. The cell 1 value was entered in yesterday and still has not run the automation. There isn't any formulas set just automations which are below. The picture is the text cell and changing the status. I haven't had any problem with the emails sending.

  • Brian_Richardson
    Brian_Richardson Overachievers
    Options

    Automations vary in their responsiveness. If you need something to happen instantly you can use a formula instead. You can see when an automation last ran in the Automation list at the bottom, or look at cell history to see when the last change happened, but you cannot control the responsiveness of automations, they run a little slow sometimes when the backend is loaded or when there's a lot of simultaneous changes happening.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN