Help

airtable automation for recurring task for weekly, daily, monthly, 3 times per week and twice a mont

Topic Labels: Automations Formulas
158 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sakshigupta
4 - Data Explorer
4 - Data Explorer

Hi ,I am creating an airtable automation for recurring task for weekly, daily, monthly, 3 times per week and twice a month  In the next to perform date i used this formula DATEADD({Due Date},SWITCH(Frequency,'DAILY',1,'WEEKLY',7,'MONTHLY',30,'TWICE A MONTH',15,'3 TIMES PER WEEK',3),'days') It works perfectly well for daily, weekly and monthly, twice a month but it doesn't work for  3 times per week i need (Monday, Thursday and Sunday)
can you please help me with the formula?

0 Replies 0