Skip to main content
Solved

Formul for changing tohe status to archive

  • February 22, 2021
  • 3 replies
  • 28 views

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!

Best answer by augmented

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!

3 replies

Forum|alt.badge.img+3
  • Participating Frequently
  • February 22, 2021

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


Forum|alt.badge.img+18
  • Inspiring
  • Answer
  • February 22, 2021

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!


  • Author
  • New Participant
  • February 22, 2021

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!


Of course…thank you for your help!