I have a business that deals with a single recurring service, typically occurring every 1-3 years. My intent in using Airtable is to manage all of my Contacts, Services Performed, and the ability to identify when a Contact is due for a recurring ser...
So I know this shouldn’t be all that difficult, and I get the results for my first two outcomes (Blank and 1 Year), but no years past Year 1 provide an answer.
IF({Last Service Date}=BLANK(),BLANK(),IF({Service Frequency}=“1 Year”,DATEADD({Last Servi...
The primary point that I cannot appear to get to link correctly is all dates a service has been performed for a particular contact in the Services Performed table to be displayed under the individual contact in the Contacts table. Once I get that, I...
