Updating Google Sheets will fix your messy formulas

What do you need to know? Google Sheets has received a new update that helps solve formula problems – it detects what could be improved in your formulas and recommends an update using context-aware updates.

PCPress.rs Image

Intelligent updates to help debug formulas

You can disable this feature if you believe the recommendations are out of place.

Google Sheets gets a new handy feature to help you improve your formulas and solve problems using context-sensitive updates. Google said in a blog post that these updates are intended to help you “write formulas faster and with more confidence.” Smart updates can also fix various formula errors, such as VLOOKUP errors, missing cells in range entry, and range locking when formulas are applied to cells.

It is available to all Google Workspace users, G Suite Basic and Business users, as well as owners of personal Google Accounts. The new tool is turned on by default and there is no administrative control for it. However, you can disable it by going to Tools > Enable formula corrections. Google is currently in the process of introducing this feature, but it could be several weeks before it becomes available to everyone.

Source: Androidcentral


Source: PC Press by pcpress.rs.

*The article has been translated based on the content of PC Press by pcpress.rs. If there is any problem regarding the content, copyright, please leave a report below the article. We will try to process as quickly as possible to protect the rights of the author. Thank you very much!

*We just want readers to access information more quickly and easily with other multilingual content, instead of information only available in a certain language.

*We always respect the copyright of the content of the author and always include the original link of the source article.If the author disagrees, just leave the report below the article, the article will be edited or deleted at the request of the author. Thanks very much! Best regards!