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
Try these Zap steps:
- Trigger: ClickUp - Task Changes
- Specify the conditions
- Action: Delay - For
- Time: 24 hours
- Help: https://zapier.com/apps/delay/integrations#help
- Action: ClickUp - Find Task
- Use the Task ID
- Action: Filter
- Check the status
- Help: https://zapier.com/apps/filter/help
- 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.
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
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
- Used to get an output value from a lookup value
- Formatter > Date / Time > Add/Subtract Time
- Used to get the new date
RESOURCES
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.
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
You are completely right. Screenshots would probably help.
I am uploading in the attachment. Thank you one more time.
Petar
Hi
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.
Hi
Sure thing. We're glad to help. Just keep us in the loop so we can assist you if necessary. Thank you.
“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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.