Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

An Automation to update Date based on choice of a Single Select option

Topic Labels: Automations
Solved
Jump to Solution
789 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!

I’d like to have a set of single select options that indicate a follow-up timeframe. Example: 2 weeks, 1 month, 2 months…

I’d then like to have an automation generate what that date would be, where the automation would take the record created date + that amount of time (2 wks, 1 month, etc.) The date generated by the automation would drive a view that looks for any follow-up dates within a week’s time span.

I know how to create the view, I’m just hoping that it’s possible to create the automation to update the follow date field based on the option chosen within the single select field.

Is this at all possible? Thanks in advance!

1 Solution

Accepted Solutions

Hi Cole. There you go making the solution more difficult than necessary :slightly_smiling_face: You just need a formula field.

DATEADD({Created},SWITCH({Follow Up},'2 weeks',14,'1 month',30,'2 months',60,0),'days')

Where {Follow Up} is your single select field with options for ‘2 weeks’, ‘1 month’, ‘2 months’ - obviously you can customize to your needs. The zero is the default number of days which you can change as well.

Hope I understood you clearly and that this works.

See Solution in Thread

2 Replies 2

Hi Cole. There you go making the solution more difficult than necessary :slightly_smiling_face: You just need a formula field.

DATEADD({Created},SWITCH({Follow Up},'2 weeks',14,'1 month',30,'2 months',60,0),'days')

Where {Follow Up} is your single select field with options for ‘2 weeks’, ‘1 month’, ‘2 months’ - obviously you can customize to your needs. The zero is the default number of days which you can change as well.

Hope I understood you clearly and that this works.

@augmented I guess I did, though this time I honestly NEVER would have come up with a formula like that, so I’m glad I asked!

Thank you again for your quick assistance and answer.