I’m sure there are other ways to do this, but I think the quickest way to accomplish this without breaking your existing structure would simply be to split up the bookings that straddle different months. Then all of your lookups and rollups in the Mo...
Hi there! Welcome to the Airtable Community!
If I understand correctly, I think it would just be separating them out, and returning blanks if the field is empty.
Try this:
IF({Field 1}, "Mary","")
&
IF({Field 2}, "Bob","")
&
IF({Field 3}, "Jake","")
...
Ah, I see - Sadly, I do not believe there is a native way to accomplish that. You’re essentially describing a conditional selection limitation. While AT forms have both limitation and conditional capabilities, they do not have them combined!
I would...
How many companies do you need to account for? There is a way to accomplish this pretty easily with conditional form fields and company-specific views, but it isn’t scalable and will become prohibitive the higher number of companies you are trying to...