Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Adding upcoming dates to interface dashboard

244 0
cancel
Showing results for 
Search instead for 
Did you mean: 
steviecampbell
4 - Data Explorer
4 - Data Explorer

Hi, I am wondering how to display approaching deadlines based on a dates that are 1 month out and 2 weeks out to be displayed on an interface dashboard but I am unsure how to make this happen.  Thanks! 

2 Replies 2
Saravanan_009
8 - Airtable Astronomer
8 - Airtable Astronomer

Create Formula Fields to Calculate the Deadline Ranges.

One Month Out Field: IF(AND(IS_BEFORE({Deadline Date}, DATEADD(TODAY(), 30, 'days')), IS_AFTER({Deadline Date}, TODAY())), "Within 1 Month", "")

Two Weeks Out Field: IF(AND(IS_BEFORE({Deadline Date}, DATEADD(TODAY(), 14, 'days')), IS_AFTER({Deadline Date}, TODAY())), "Within 2 Weeks", "")

By using formula fields to calculate whether deadlines fall within the next 1 month or 2 weeks, and then filtering and displaying these records in your Interface dashboard, you can effectively monitor approaching deadlines and keep track of important dates.

Hm, I'm not really following sorry.  May I know what the business logic is?