This will prevent all sorts of crazy work arounds when all your trying to do is copy a value generated by a formula onto another sheet. EX. Creating a formula to create a value that you want to use to create a reference sheet.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.