Formula Drilldown Highlight for Relevant Sections (esp. IF statements)
It would be really helpful if formula drilldown could highlight (maybe bold or with colors) the sections of a formula that actually apply in a specific calculation.
For instance, in formulas with nested IFs, a lot of it will not apply in a particular calculation because the IF condition is not met. However, that is often difficult to tell at a glance. It can be very time consuming to check each condition to determine which one(s) actually apply.
Being able to quickly identify the relevant parts of a formula would make it a lot easier and more efficient to troubleshoot, especially when dealing with very long & complex legacy formulas.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!