Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jul 31, 2019 07:47 AM
Hi, I am interested in using a conditional formula to either automatically select from a single drop down or to use a phrase with emojis.
{Program Status}
In this field I want to indicate in one field if a program is:
In Progress
Complete
Future
{Program Start} and {Program End} or {Program Start and End}
I have a field for start date and a field for end date (or I can create one field and type a range)
I am looking for a formula that will automatically generate a {Program Status} based on today’s date. I would appreciate any help. Thank you!
Jul 31, 2019 08:00 AM
Hi @Alix_Boyle - have a look at this post and answer, which is pretty much what you need, I think:
JB