CODA Automation problem

[Gen_Garcia]

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.

[Pablo_DV]

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

TL;DR Guide for new Coda-Users: How to share a doc with the Coda Community. 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?