Hi @willmoga,
Absolutely! You won't see where someone else is viewing/clicking but you will see any edits they've made. Airtable is designed for collaboration and has a ton of features to make this seamless such as @ mentions, record revision history, base/field permissions, to name a few.
By workbook, do you mean an Airtable base?
Yes, multiple can work in the same Airtable base at the same time. You can even work in the same Airtable base yourself in multiple windows or devices. (I actually do this a lot.)
If someone else changes a value in a grid view that you are in, you will see immediately that the other person made the change.