Peer Support

I have a smart container with over 300 items and growing for tracking of a project. I would like to use the dynamic shapes with a formula as the value to display the percentages complete for different categories. I am unsuccessful at attempts to get a reference for the contents in the container itself or the shapes inside them to access their property values. I am able to use conditional formatting rules rather easily based off of the shape data properties.Example: 1 Smart Container 8 Overall blocks  (levels) 300+ items - Each item has a "Content Status" property. If I needed to show how many are complete on the first level I need to display: total number of shapes with "Level"=1 & "content status" = "complete / total number of shapes with "Level" = 1 I've tried incorporating the container.contents() and the count(contents()) formulas and keep getting returns of an empty array or 0. 

I have imported data and I need to sum a column of data if another column of data is = to specific text. Below is my initial formula but I keep getting an error.  =SUM(@"Annualized Cost") AND(x => x."Worker Status" = "Active"))

Hi I was inspired by the feature reveal on 5/16 that showed a budge that changed as collaborators dragged features into a certain area of the chart; this was set up using dynamic shapes and formulas. I would like to do the same with dynamic shapes that reference story points on Jira cards; ideally collaborates could drag jira cards into a box on the chart and see a total of the story points in that area. I have been able to get a sum of the story points of jira card that are grouped together but haven't found a way to set up an area where cards can simply be dragged into and then the story points only from those cards added up. I have tried using containers but these don't seem to have any relationship to the enclosed cards they only magnetize them. Is there a way to use formulas to reference certain objects based onto an area (shape/container/smart container/frame/etc.) that they are dragged into/on top of or is the only way to reference certain objects to manually group them together

I have created custom hover text on conditional formatting, but I am unable to find a post or video on how to use it after the formula is inputted. My goal is to count the number of “children” in each container, so I do not have to do it manually as my chart grows. After researching this topic, I believe the proper formula on the custom hover text to be “=COUNT(children)”. Is this the proper formula to use for what I am trying to accomplish? If so, how do I view the custom hover text equation on my containers?

Is there a way to pass parameters (data) from one shape to another based on an action?  I’m trying to populate a stationary shape with the description from a shape that I select.  The shapes I’m using have data linked to them.  I see that the IDE has a “Selected objects” section, so I was hoping there was some way to use the Lucid formulas to accomplish this.  Any help would be appreciated.

Hi,If I have multiple ID Cards/nametags inside of a frame, is there a way to have a counter or enter a formula to see how many cards are in the frame?We are using Lucid for a virtual staffing board, and instead of counting the nametags manually, we wanted to just drag and drop and the counter move up or down based on # of nametags inside the frame. Also, I did search for older topics but the 2-3 I found were 1+ yrs old and did not have a solution at the time. Thanks,Justyn

I would like to display a sum of the durations of an set of objects that are grouped together.The objects have linked data.I create a custom field "Property 1" which is =SUM(children."Call Durations")It does return a value.  But I do not know how to get that value onto the page!  For Static Custom Values or linked data there is usually a "=T" symbol which will put the field on the object.  But in the case of a Group... there is no +T.... so how do you actually get the value of this computation to display on the page?The article "How to Use Formulas" example shows how to make the calculation but not how to put it on the page.My hope is to be able to sort items into groups and have the calculation show the total duration.  That way as we are making decisions  about what to group together we can see what the total duration is. 

I'd like to upload an excel file with a table of data so I can have data driven objects. Can I somehow reference the data file(s) with rows and columns and use them in formulas etc?

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

Previously posted - still cannot get a very VERY simple formula to add a result into a shape in a diagram.    As you can see my data table is SIMPLE. My formula is SIMPLE. Clearly there are a number of rows that displays text in the Progress Indicator column that match my formula (i.e. how many rows have the phrase 'ON TRACK' as the Progress Indicator). The answer by the way is 19 rows out of a total of 38 rows in the table. Lucid Chart gets the answer as '0'.     Posted previously - followed advice and got nowhere. Weeks on and still stuck on trying to do a very very simple thing that should take less than a minute. I mean come on guys seriously my job is at stake here 

I imported data using the org chart function with a column for FTE counts. I can write a formula when clicked into the org chart to total the FTE counts (=sum(children.'FTE') but there isn't the +T option to add a text box with that count. When I try the same formula not clicked into the org chart just the page it doesn't work. I tried LOOKUP formulas too with no success; it's like it can't read the org chart data I imported (which does not show up in the linked data panel either). Is there a way to use formulas and add them to your document when using the org chart feature? 

Hi I have a countif formula {{=COUNTIF(DESCENDANTS(page)AND(@'System'='OBT'@'Workflow'='Online Execute'))}}result for example = 10How do I create another formula to use the result and multiply by another formulaI was trying below but get error{{=COUNTIF(DESCENDANTS(page)AND(@'System'='OBT'@'Workflow'='Online Execute'))*ASNUMBER(@'Online Air GDS Numbers')}}

Hi - I have an org chart where I am trying to calculate the number of people by their role. When the org chart is expanded the formula works as expected but when the chart is collapsed it only counts the visible shapes. How can I get it to count all shapes whether they are visible or not?

Does Lucidchart provide a formula or a hack to perform dot product (similar to sumproduct in excel) for 2 arrays?

When creating a conditional formatting formula to get the fill color data of the parent shape, I was having trouble getting it to pull from the upstream shape, instead of (I’m guessing this is where it was pulling from) the page itself. The plan was to eventually put this into an if statement, but it wasn’t working.An Example of it pulling #ffffffff instead of the color of the previous box Even if the example output on the formula window is pulling from the page as a whole, it doesn’t work in the example as follows, with the if statement either:This is probably some weird formatting issue, but I hope someone can help

I have data of the form below where various splits are being made at various values in the fields that I would like to automatically create a process flow for with those values noted at the split.  I could manually do this but I'm looking for a tool that will read in a data file of desired layout and create a process flow.  Can I do that with Lucidchart?  Thanks!

Hi!  I'm new to Lucidchart and am looking for a way to =SUM numerical values within particular flowchart fields.  I would also like for the calculations to automatically change as fields are updated.  I looked into Importing Data from csv (where calculations are already made) but it doesn't meet the visual aspects that my company prefers.  I also looked into Smart Containers to see if that would be a solution but honestly am confused by how the basics of those work.  Is there a way to do these tasks and if so is there a basic tutorial on how to do so?  Thanks! 

Hi, I'd like to visualize the structure of my Google Drive folders as a folder tree. Is there a way to do that in Lucidchart? Or a work around like for example by syncing my Google Drive to OS X first; creating a csv file from an OS X folder structure first and then import that data from a google spreadsheet or ANY OTHER WAY ;) Thanks for your help!

Where can I find an import definitions file or something of the sort so that I can create a CSV file to import? I downloaded the example. But there are far more actions that can be done and I dont know what each cell means. Is there somewhere that has each name, shape library, page ID, etc for a FlowChart so I can make my own?Also where can I find directions on how to link to google sheets?

I have been using import to Smart Containers feature and works well creating graphs such as Product Roadmaps.  My question is once the data has been imported using Smart Containers how do i edit the data?  I noticed if i click on the Data Panel there is no reference to the data imported.  I was able to use right Contextual Panel and see the imported file but every record just says COPY but i am unable to actually change a value of what was imported.  I tried to import data using the Data Panel and edit the content but was unable to use the Smart Containers feature - am i doing something wrong here ?oh and i was using CSV files 

Hello,I imported a .csv file containing staffing information and selected the option to generate separate org charts by a field (department).  The result was over 20 different org charts, which is fine and expected.  However, I had to apply the conditional formatting, shape styles, and employee fields to each page separately.Is there a way to apply conditional formatting rules, org chart shape styles, and org chart employee fields (selecting the fields and arranging the order) to every page at once?  What if I set it up ahead of time, can those be applied when I import the data?  Thanks in advance!

Lucidchart Mavens Because I was told that Lucidcharts supports generating diagrams by importing CSV files I just signed up with the aspiration of generating a simple flowchart (dragging dropping moving and connecting is a ton of NO FUN). FOILED AGAIN? However after frantically searching the Help files (etc.)...I cannot find a way to import a CSV file...generate a flowchart...nudge it around a bit with the graphical tools...then export it back to a CSV file. HOPEFUL Hopefully I've overlooked something quite simple and CSV importing/exporting is buried away somewhere in a not-so-obvious menu. SUGGESTIONS? What's the best thing to do to import/export CSV source files to generate/save Flowcharts in Lucidcharts? Your ideas? Suggestions? Many thanks! Rick

Hi  I've been trying to produce quite a complex process diagram using the csv import process. However i've become very confused as when LucidChart renders the diagram it doesn't keep the line structure which is determined in the CSV.  What I'm left with is a mess of a diagram that doesn't make sense and well....see for yourself... Am I doing something wrong with the CSV? Any help/advice would be much appreciated.   Example extract of csv....   Extract of the rendered process...      

Hello I'm building diagrams with components to be used in a project. Each shape represents a component needed and in some cases we need multiples of the same shape. I'd like to create a materials list based on the shapes used in a diagram and ideally if multiples of the same shape are used then this will automatically be indicated in the "qty" field of the CSV file. Is this possible? Thanks!

I would like to create a customer journey offline in CSV format then load into one of the existing Customer Journey Maps in LucidChart.  I was able to do this with Smart Containers and Product Roadmaps but i cant see how i can do the same thing with Customer Journey. I was able to import the data but looks like the only way to do this is to create a chart one shape at a time - this will take me hours to map the data to individual shapes. I was hoping i could connect from the CSV and just chose the Customer Journey template . Any help appreciated.