Formula Drilldown Highlight for Relevant Sections (esp. IF statements)

helennie

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.

wwood

Another vote for this functionality, this would be extremely helpful.