I would like to create a formula to display the following status for our CYCLE spreadsheet.
- Cycle is ongoing
- Cycle has not begun.
- Cycle has ended.
So there will be only 2 date fields ( Date: Start and Date: End) to indicate when the cycle is scheduled. How do I design the formula code for airtable to identify that the date today isnt between date: Start and date: end or hasnt even started and also if the date has ended for the cycle.
Thank you guys!