I have been struggling with how to do this using Zapier Tables
I want to flag when a task is past the due date, due today or due after a certain number of days.
I want to trigger a zap that changes the value in a drop down menu so it will move to a different column in the kanban form I’m building.
Originally I tried creating a zap that triggered when a record was updated and I was going to use paths based on what the formula value was. BUT none of my test runs recognized the new values.
Please let me know if there is a better way to do this. (The AI has absolutely useless for anything other than “create these 10 fields”
Best answer
How to trigger a Zap when a formula field is updated in Zapier Tables
- Beginner
Best answer by Fahad S
Hi
You can try this approach:
Step 1: Click the name of your formula field in your Zapier Table (the one that calculates due dates)
Step 2: Select "+ Create Zap" from the menu that appears
Step 3: A new Zap opens up with the trigger already set to watch specifically that formula field
Step 4: Now add your action to update the dropdown menu that controls your Kanban column
The trigger will be set up as an "Updated Record" trigger, but it'll have your formula field pre-selected in the configuration. So it's using the same trigger name, just configured differently .
Documentation:
Hope this helps you get it sorted!
- Zapier Solution Partner
- Answer
Hi
You can try this approach:
Step 1: Click the name of your formula field in your Zapier Table (the one that calculates due dates)
Step 2: Select "+ Create Zap" from the menu that appears
Step 3: A new Zap opens up with the trigger already set to watch specifically that formula field
Step 4: Now add your action to update the dropdown menu that controls your Kanban column
The trigger will be set up as an "Updated Record" trigger, but it'll have your formula field pre-selected in the configuration. So it's using the same trigger name, just configured differently .
Documentation:
Hope this helps you get it sorted!
+11- Community Manager
Glad Fahad was able to point you in the right direction
- Beginner
+11- Community Manager
That’s so nice to hear
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.