How do I build a zap to check Clickup ticket status after 24 hours and send updates to Slack?

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

• Save a Step by Adjusting Date/Times with Modifiers

​@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.