ITEM function cannot be used on composite lists with Summary of "Formula"
1. Create a parent list and a composite child list.
2. Create a module with 1 line item with formula "ITEM(Child List)" and list formatted to "Child List". Applies To should be "Child List".
3. Change Summary to "Formula", the following error is shown:
The formula for 'mod1'.'item1' is invalid:
'item1' = ITEM(Child List)
'item1' does not apply to Child List
('item1' applies to Child List)
**Note the error says the line item does not apply to the list, even though it does!
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!