Hi Monica thanks for posting in the Lucid Community! I'm happy to help. In order to help me better understand your setup and the formulas you have attempted could you please respond with a screenshot of an example smart container and a screenshot of the formulas you've attempted as you've entered them into the dynamic shape formula field? This additional context will help me take a closer look. Thanks for your help and patience!

I've been playing with the formulas in the visualize field to see what they are returning as well as in the dynamic shape. I'm having a hard time even being able to get an array to populate of the smart container.  I've tried utilizing page siblings container and several other routes to see if I can get access to either the container properties or the properties of the items themselves. Ultimately I need the properties of the items with "content status" to be able to calculate the percentages.

Hi Monica thank you for getting back to us with that specific question. You will need to create a custom data field (example title "number complete" for your dynamic shape that counts the total number of descendants with "Status" = "Complete". This can be done using the =COUNTIF() function (refer to our full formulas documentation for more information):

=countif(descendants(page) x => x."Status" = "Complete")

Next you can reference this newly created data field (e.g. "number complete") to calculate the percentage by dividing by the total number of descendants with the property "Status" (in your example this value is seven).

You might also find this community post from another user with a similar question helpful! I hope this helps - please let me know if you have additional questions. 

Hi! Jumping in here to share about Lucid’s Data Trusted User Group. This group is made up of knowledgeable users who regularly analyze and visualize data in their work. As part of this group, you’ll have the opportunity to connect directly with Lucid’s product team, gain early access to beta features, and share insights about your needs, shaping the future of Lucid’s data solutions 🎉 You can learn more and request to join here. Thanks!