Hi @RNoz 
Welcome to the Box Community! I’d be glad to assist.
Please refer to the answers below in bullet points:
1. I’ve tested this and some people can edit the doc and some cannot and are asked to create a login, I don’t know why the difference
- It looks like you're inviting collaborators to edit content on your shared files. As outlined in the Collaboration Frequently Asked Questions: Users must have a Box account to collaborate on content in Box. If you send a collaboration invitation to an individual without a Box account, that individual will be prompted to sign up with Box before being able to access the content.
- Collaboration provides a two-way relationship; depending on their access level, collaborators can view, edit, upload/download documents, leverage collaboration tools (comments, tasks, and so on.), and receive updates on actions taking place in the folder.
2. Does this have price implications for by box account for any reason?
-
This depends on your subscription and how you manage Box. Plans such as Starter and Business do not offer unlimited collaboration features. Inviting collaborators will result in seat overage. If you need to collaborate extensively, the lowest available plan with unlimited collaboration is Business Plus. For a side-by-side comparison, please visit our pricing page: https://www.box.com/pricing.
To keep accounts in compliance with Starter or Business subscriptions, the following options are available:
Admins can purchase additional seats for collaborators.
Admins can upgrade the account.
Users can remove collaborators and utilize shared links.
(Note: Unlike collaboration, individuals accessing your content through a shared link will have "read-only" access and won’t be able to make changes to your files. Users can access content with or without a Box account, and they will not count as collaborators.)
Related topic and resources:
For your query about Google Sheets, I'm checking with our support team to confirm whether the Box for Google Workspace needs to be disabled by the admin. We'll follow up with you once we have an answer. 
Hello @RNoz
For question 2:
Is it possible to turn off the option to open in google sheets so as not to cause confusion (this would disrupt existing formulas in the spreadsheet)
- The admin can disable the Google integrations by accessing the Integrations > Individual Integration Controls > Box for Google Workspace configuration within the Box Admin Console. Please be advised that aside from Google Sheets, this will also prevent users to access other apps such as Google Docs and Slides.
Please let us know if you have other concerns/questions. 
@Jey Bueno Box this is super helpful thank you for your time. Clarifying question on disabling google integrations. Can the admin disable this integration for specific folders/docs or will it apply to all
Hello @RNoz You’re most welcome! At the moment, disabling integrations only applies to all and we’re unable to configure it to specific folder/docs. Thank you. 
