When I want to delete a calculated field and it has been used in worksheet(s) or other calculated field(s), there will be prompts.
Case 1: When it has been used only in a few places, the message will tell me where.
Case 2: When it has been used in too many places, the message will only tell me there're many places but not where.
For case 2, it takes time to trace the relationship.
Not only for the purpose of deletion, when I want to modify a calculated filed, I'd also like to evaluate how much this modification will influent.
Requirement for a trace tree might be too much, so I only want a list of affected items by two categories.
- Calculated fields
- Worksheets / dashboards / stories