# CODA Automation problem

**URL:** <https://connect.superhuman.com/t/coda-automation-problem/54789>\
**Category:** Ask the Community\
**Created:** [March 26, 2025, 8:41pm UTC](https://connect.superhuman.com/t/coda-automation-problem/54789 "2025-03-26T20:41:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gen\_Garcia](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gen_garcia/32/44322_2.png) [@Gen\_Garcia](https://connect.superhuman.com/u/Gen_Garcia)\
**Post date:** [March 26, 2025, 8:41pm UTC](https://connect.superhuman.com/t/coda-automation-problem/54789/1 "2025-03-26T20:41:30Z")

</div>

Hi there! I’m currently working on a formula to set up a slack automation to send out reminders as contractors’ end dates are approaching. I’ve set up columns for:

1. Team Member
2. Contract End Date
3. Button for slack
4. Messaging to be sent to slack once it’s been triggered

and also turned on the automation for this. The problems are;

1. The messaging formula isn’t working. I wanted to customize it and pull info from Team Member and Contract End Date. And message should say ( “Team Member”'s contract is expiring on “Contract End Date”. Please reach out to their managers to discuss next steps. )
2. How do I customize a button formula to only light up when it’s 2 weeks prior end date and only 3 days prior end date.

---

<div class="post-metadata">

**Author:** ![Pablo\_DV](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pablo_dv/32/49028_2.png) [@Pablo\_DV](https://connect.superhuman.com/u/Pablo_DV)\
**Post date:** [March 26, 2025, 9:33pm UTC](https://connect.superhuman.com/t/coda-automation-problem/54789/2 "2025-03-26T21:33:16Z")

</div>

Hi @Gen_Garcia,

It would be very helpful if you could share a dummy doc.

> [@Guide: How to share a doc with the Coda Community](https://connect.superhuman.com/t/guide-how-to-share-a-doc-with-the-coda-community/47043):
>
> TL;DR Guide for new Coda-Users: [How to share a doc with the Coda Community](https://coda.io/@jannis/coda-community/how-to-share-a-doc-with-the-coda-community-16). Copy and paste it into all topics where there is insufficient information. Long version: Hello folks, This is my first post in this category. I don’t think this post has much added value, but I decided to publish it here anyway. In the last months, I have often seen that new users, in particular, need help, but are not aware that it is extremely important for us to share their document, add a screenshot or anything…

> [@Gen\_Garcia](#):
>
> How do I customize a button formula to only light up when it’s 2 weeks prior end date and only 3 days prior end date.

Let me rephrase that to see if I understood: do you want a button disabled except when today is 2 weeks before the end date or later?

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [June 24, 2025, 9:33pm UTC](https://connect.superhuman.com/t/coda-automation-problem/54789/3 "2025-06-24T21:33:23Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.