Hi Fred welcome to the forums!
Simple answer, no.
Long answer, no, but getting a better understanding of how Airtbale works may give you a better solution than what you're trying to achieve.
Since Airtable is a database and not necessarily a spreadsheet, the formula you're trying to make wouldn't work. Information stored on each record is not able to change dynamically from view to view. However, implementing "Link" fields, "Look Up" fields, "Roll Up" fields, and "Formula" fields will come in very handy when we have data interacting with each other.
Hopefully, you do a bit of playing around to see if Airtable works for you. It's very exciting when you're able to implement and build your own systems and infrastructure.
I'd suggest having a look at the bases others have built over on the Airtable Universe for inspiration haha
@Fred00 Since you are new to Airtable, you might enjoy my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/