Help assign value through Formulas to Dynamic shapes for Dashboard creation

Question

Hi
I'm trying to create Dynamic Dashboards on a Kanban board. I can't seem to assign a value to my dynamic shapes based on the information created on my Smart Container panel . For instance I was able to create a formula to calculate the % of items with the Status 'Done'. I would like to assign that number as a value to my Dynamic Shape.
Is there a way for it to read the number from the Lucidchart container data and NOT from the Google Sheet linked to the board?
I also understand the data linking with Google Sheets is not a 2 way link so if for example I move a card from 'In Progress' to 'Done' that information does not update on my Google Sheet. Is there a way to update that info on the Google Sheet directly from Lucidchart?
Since I don't think there is that's why I would like my dashboard to read that information from Lucidchart and not from Google Sheets so that it automatically updates when I move a card from one status to another.

I have tried to use the formulas syntx but keep getting 'Error' no matter what I do. I though the formula would be =Parent."% Done" but I'm obviously wrong. I've tried a number of things and I'm getting nowhere.
Thank you for your help!

Abigail M · Accepted Answer

Hi Laura thanks for posting in the community! You can reference the value of a calculated field by using the following formula:

=@"[Your Field Name]"

If you would like to count the number of objects in a section you can apply the following formula to a smart container:

=COUNT(CONTAINED(this))

You can also count contained shapes conditionally using the following formula:

=COUNTIF(CONTAINED(this) DOESNOTCONTAIN(@"Cancelled" "true") = true)

In the future I would strongly recommend referencing our Lucidchart Formulas cheat-sheet when building dynamic formulas.

For anyone else working with formulas please check out our Formulas in Lucidchart Help Center article for a quick intro and our Formulas Developer Documentation for a more in-depth outline.

Micah · Answer

Hi! I’m Micah from Lucid’s community team. 👋 I thought you, and any others who might come across this topic in the future, might be interested in 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!

Create an account in the community

Log in to the community