Hi I am converting a Google sheet to Airtable. In Google sheet I have a formula that:
- Counts down 7 days from Last touch to 0, this acts as a reminder.
- If a follow up date is set, it counts down the number of days from the reminder date
- If certain conditions are met (e.g. dead/stop) shows '-"
You can see it working here:
The formula I am using is:
=if(and(F2>0,F2>E2),F2-today(),if(or(E2=0,C2=“11 - stop”,C2=“11 - dead”,C2=“09 - lead (Booked a call)”,C2=“10 - sale”,C2=“08 - email follow up sent”),"-",E2-today()+7))
Can you please help me to write this in Airtable?