I don't thing there is any setting in Smart View that can actually does it.
I can think of two options...
1. Do it within the system (If it is Essbase/planning) to the functionality you are expecting
2. As you are saying lot of formulas, I think you can prevent those formulas and use Excel VBA Macros along with Smart View API and build the logic what you wanted...I know this would be a lot maintenance when your templates change a lot