The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi there. I am trying to write a formula ("Duration of Pending Repayment") that calculates how long an unpaid repayment is overdue.Essentially, it will be:If "Repayment Due Date" is not blankAnd "Repayment Received Date" is blankThen calculate Today-...
Hi there - I am attempting to track contract breach status (pending, resolved, or n/a) depending on the source of the breach and whether there is a specific response date. My formula will be 5 if statements, of which 4 are also if/and. I've been abl...
Hi all - I work on a team that manages contracts and all of our data lives in Airtable. We use Favro, however, to track cross-team work to resolve post-contract enrollment issues. I then create a new row in a "Post-Enrolled Issues" table of our base ...
Hi there - I keep getting hung up on lookups and links and it's driving me bananas so it's time to phone a friend! To generalize, I have a "Counterparty" table that lists all of the counterparties our organization has a contract with that includes th...
Hi there and Happy Friday!I am trying to calculate the time it takes an individual to get a specific type of number at the time they enroll in our program.The formula I have is essentially, "If the individual does not have a preexisting number, calcu...
Thank you, Alexey! Appreciate the time you took to assist!First, the column should have been single select, good catch! I was playing around with a multiple select option since in some cases one contract may have multiple breaches, but decided agains...