Help

Formul for changing tohe status to archive

Topic Labels: Formulas
Solved
Jump to Solution
1110 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Hannah_Dorling
4 - Data Explorer
4 - Data Explorer

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
augmented
10 - Mercury
10 - Mercury

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
Raminder_Singh
7 - App Architect
7 - App Architect

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

augmented
10 - Mercury
10 - Mercury

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!