Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formul for changing tohe status to archive

Topic Labels: Formulas
Solved
Jump to Solution
256 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Solution

Accepted Solutions

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

image

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

image

Good luck with this!

See Solution in Thread

3 Replies 3

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

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

image

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

image

Good luck with this!

Of course…thank you for your help!