I have a Google sheet where I'd like to conditionally convert a formula range into its values (effectively locking them). I've searched for a function I could embed in a IF statement but don't think that's possible. I have reached my limit on what I can do. Anybody have ideas?
Below is a link to a scrubbed demo version. Please let me know any ideas you have.