List item has nothing showing in 'Referenced in Formula', but it is referenced?

edited March 2023 in Modeling

I have a list that shows no references, and i was removing ‘dead’ lists however, when i tried to delete it i got an error saying it was used in a module.

And after looking i found it was indeed used

So why does the reference not appear in the list information?


Best Answer

  • AjayM
    Answer ✓


    The formula appears to be using the properties of Allocation Data# list, which can be identified in the properties tab of respective list.
    The formula reference would appear in ‘General lists’ tab when the list is being used as part of functions like FINDITEM, SELECT. It doesn't summarise the properties' usage in this view.

    Side note: While it's not recommended to use properties for a list, and rather replace them with SYS module, my guess is this is a transactional data related list that is part of integration.



  • Thanks that make sense, and the development ongoing is to remove the list references…but.. it's slow going
    thanks again

  • AjayM

    Well, that makes it another reason to have these attributes as lineitems. In that way, we would identify the references in ‘Applies To’ and thereby do the cleanup.

  • Now i have a System module and all calcs and sums are from that.

    Only 50 more lists to convert..