Hi, I hope I’m posting in the right place. Brand new to Airtable. My goal is to set up a CRM for networking that will remind me when to reach out. My plan:
- Each person (record) gets a numeric rating to indicate how often I want to be in touch with them.
- I will have a field where I manually enter the date of most recent contact.
- I want another field that will calculate the next date needed, based on the rating. So, if the rating field has a 1, the field with the next contact needed will be 30 days, if the rating is 2, 60 days, etc.
- I’d like conditional formatting to turn the record a different color if I’m overdue.
I am really not well versed with formulas or functions so I have no idea how to set this up.
Can anyone help me? Thank you!