Archiving an Airtable

[Hannah_Dorling]

Hi Everyone, I’m new to formula’s and can’t quite work out the right answer.

I have job listings that I want to archive once they have passed an expiry date. I currently have a status column that has a dropdown to select ‘archive’, once this is selected it goes onto another view (using a filter) but it would be really useful to automatically move this once it reaches the expiry date’, rather than doing it manually.

Thanks in advance!

[Raminder_Singh]

What about this formula for Archived field: IF(IS_BEFORE({Expiry Date}, NOW()), "Yes", "No")?

[augmented · Accepted solution]

Hi Hannah. I think that you want to use an automation for this problem. This is what your trigger might look like.

For the action, you’ll want to update record maybe like this.

Good luck with this!

[Hannah_Dorling]

Of course…thank you for your help!