Hi, very interesting Airtable project !
Based on my experience this can be easily achieved.
You can have Your formula solution, simply give me the description of the real need, I will send You back the formula on Airtable platform :)
Feel free to contact me for any clarification or question that can get the success of your goal
Cheers
Gianni