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...
Oh hello there! I am working with a team that is developing a base to capture competitor profiles. Within the base we have an organizational overview tab, contacts tab, program information tab, and a SWOT Analysis tab where we'd like to fill out the ...
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...
Wow, thank you so much for offering your expertise! I think what I'm looking for is in the first screenshot but I do like how you summarized the data in the third too! Do you have to manually add the "Counties<>States" link in the Counterparties tabl...
