Skip to main content

Hi everybody. Thanks for the help in advance.

I tried using Copilot for this but I think the option given is missing step(s).

I am trying to build something that sounds simple. Every time that ticket in a certain ClickUp list goes to status “Working” I want to activate a countdown of 24 hours and then after the countdown is done I want to see if the ticket is still in the same status. If yes, then I want to notify a channel in Slack. If not, zap stops.

Again thank you for all the help.

Hi ​@Petar Krstic 

Try these Zap steps:

  1. Trigger: ClickUp - Task Changes
    1. Specify the conditions
  2. Action: Delay - For
    1. Time: 24 hours
    2. Help: https://zapier.com/apps/delay/integrations#help
  3. Action: ClickUp - Find Task
    1. Use the Task ID
  4. Action: Filter
    1. Check the status
    2. Help: https://zapier.com/apps/filter/help
  5. Action: Slack - Send Channel Message

Dear Mr. Troy Tessalone,

I want to thank you for helping me with this.
I tested with 2 hour delay last night and looks like it is working exactly how I needed it to be.
One more time thank you very much.

Best,
Petar.


Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.


@Troy Tessalone 
I have a subquestion here.
Would you have any solution that would not take weekend days into account? Basically, to skip counting over the weekend. Thank you in advance!


Hi ​@Petar Krstic 

Try this logic…

  • Formatter > Date / Time > Format
    • Format as dddd to get the day of the week
  • Formatter > Utilities > Lookup Table
    • Used to get an output value from a lookup value
      • e.g. Saturday = 2
      • e.g. Sunday = 1
      • e.g. all other days = 0
  • Formatter > Date / Time > Add/Subtract Time
    • Used to get the new date

 

RESOURCES

 


@Troy Tessalone I will try this logic ASAP. Thank you for the suggestion.


@Troy Tessalone I had to put weekend days logic aside. The filter step is not working the way I initially thought it would work. Here is what I have. In the filter configure step, the only logical option to me was Status from ClickUp - {Text} exactly matches - then I wrote down the name of the status (QC Approved). But what it does is return all the cases that have been on that status at any point, not just those that are still in QC Approved status after x hours.

 

I am not even sure if the filter can be set with these options that are currently given. I might be wrong. Any help is appreciated. Thanks in advance.

 

Best,

Petar.


@Petar Krstic 

Help us have current context by posting screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.


Hi ​@Troy Tessalone ,

You are completely right. Screenshots would probably help.
I am uploading in the attachment. Thank you one more time.

Petar


Hi ​@Petar Krstic,

 

Your Zap filter is likely returning all tasks that have ever been in the 'QC Approved' status rather than just the ones currently in it. This happens because Zapier checks the task status when the Zap runs. To ensure only tasks currently in 'QC Approved' are included, set up a trigger that runs when the status changes or use a 'Search' action to find tasks in that status before applying the filter.

 

I hope this helps. If you have any more questions, feel free to ask.


@JammerS Thank you for the suggestion. I will need to try to test this.


Hi ​@Petar Krstic,

 

Sure thing. We're glad to help. Just keep us in the loop so we can assist you if necessary. Thank you.


@JammerS Hey, thank you for reopening this for me. I did not have time at the moment you guys wrote to test that.

“Your Zap filter is likely returning all tasks that have ever been in the 'QC Approved' status rather than just the ones currently in it.” - yes. It is doing exactly that. But I am trying to get the tickets that did not change status at all after x hours. The way that Zap is set up now it will check every ticket that was in QC approved at any point but after the x hours.

Please can you elaborate more on this - “To ensure only tasks currently in 'QC Approved' are included, set up a trigger that runs when the status changes or use a 'Search' action to find tasks in that status before applying the filter.” Can you show me (screenshot) that? I am not 100% sure I understand the logic.

Also, one more thing that I am thinking about is whether should I maybe go a different way to the problem. If I am not mistaken there should be a dynamic field within ClickUp information that tells when the status was changed. So, I was thinking of checking if that changed compared to what time stamp when the status was changed initially.

Anyway, I want to them you for all the help in the meantime and I do apologize for the slow response.

Best,
Petar.


Hi ​@Petar Krstic,

 

Welcome to the Community.

To track tasks with a 'QC Approved' status in Zapier, you can either trigger a Zap when a task's status changes to 'QC Approved' or use a search action to find tasks currently in that status. For more advanced setups—like checking how long a task has been in that status—you might need to use timestamps and delay or looping steps. If it's still unclear or complex, reaching out to Zapier Support is recommended for personalized help.

I hope this helps. Please let me know if you have any other questions or if there's anything else I can assist you with.