Peer support

Lucidchart offers preset SQL statements for importing schema data into from various sql databases but does not offer a solution for Google BigQuery datasets.Can someone help me figure out a solution for this?

I am creating a smart container importing data from a google sheet.   It has dates in it and on the google sheet it has the date in the standard form.  When importing it into the smart container it converts to datevalue format.  How do I change this? 

Hello I've recently obtained a license for Lucid Chart and am attempting to import my first Org Chart from excel but have some data issues which may adversely affect the org chart I build. Below are the potential issues I have if anyone can offer any advice I'd be eternally grateful. To create the chart I need to provide the supervisor ID which I assume should match the employee ID however if I have supervisor positions that are blank how does lucid chart cope with this? Following on from the above as a work around I could run the org chart off position ID's instead as this field will never be blank for the supervisors however this would mean that I would also need to use the position ID as the employee ID also right? then if I use position ID how does lucid chart handle positions with multiple employee's in? I can update duplicate employee position ID's without issue by assigning a letter at the end hopefully but how will lucid chart work if I

Dear team,I found the possibility to add custom data fields to shapes manually, which is also available without the enterprise plan. However, it seems like all shapes have separate fields - I wanted to check if there is any way to set up the shapes to use the same data fields / single-select options across shapes so that we do not manually need to create the same data field and content for each field?I know that one workaround would be to duplicate shapes, but maybe it’s also possible to edit existing shapes in bulk?Many thanks! 

Is it possible to reference custom data on another page in the same document? I have a number on 3 different pages and I would like to total them all on the master page. I looked through the "How to use Formula's" help article but I couldn't find anything about referencing another page.

Hi all I'm making a flow chart to map out user journeys in our product. The nodes of the flow chart are screenshots of our UI and I am using the custom data fields to track our logging events for those UI elements.  If I have a shape with custom data event_name=screen_1 and another shape with custom data event_name=screen_2 for example is it possible to search for "screen_1" and highlight the shape with that custom data?

I have page data formulas and shapes with custom dataI am struggling to create another formula with 2 COUNTIF formulas Ie: count when have both dataie: Countif=COUNTIF(DESCENDANTSTHIS."System"='Online')AND=COUNTIF(DESCENDANTSTHIS."Process"='Hotel ') or Countif=countif(descendants(page) x => and(shapetype(x) = 'ProcessBlock' lower(fillcolor(x)) = '#fc9432ff'))AND=COUNTIF(DESCENDANTSTHIS."Process"='Hotel ')Thanks

I have entered a large amount of descriptive information using the "Custom Data" feature for various entities in my Lucidchart model. I would like the ability to export that outside of Lucidchart and share either as a PDF or Excel or CSV. I am unable to get this data out. The only item that gets published is the diagram. This seems like a serious gap. Anyway around this? Will be very time consuming to manually cut/paste all this outside of the diagram one by one (as I have read in some forums).

I have a custom field in a my Org Chart which I use to track whether a position is open or not (Open = Y). I'd like to add a field which looks at downstream objects and counts the occurrences of "Open = Y". This is similar to the built in "Head Count" field which is available on org charts out of the box but unfortunately I cannot see how that number is referenced in the chart please help.

Hello I'm a Process Architect and I develop Workflow Documentation for small to medium size organizations.  Many of my clients use what I develop to set up or optimize their project management software like Asana and many others however they ask how they can use the workflow as a dashboard.  Basically as they move the project through the stages in Asana how can that information than feed the workflow to show a status of all of the projects visually across the workflow?  Any ideas?

Hi there, my organization revoked my license after expiration. Now I can’t see My previously created documents. Can you please resolve an issue?  

I signed up with my school email. Currently, my account says EDU free, and I am limited to three documents on Lucidcharts. This page says EDU premium has unlimited document creation.  My question is, how can I get EDU premium applied to my account?

I am building out a recommendation for the use of Lucid, what is the best way to begin training for lucid? Using the product the same as Visio

Not an issue but a solution I stumbled upon. I've been trying to find help on panning the canvas. Couldn't find it in the Help or the Community. Happened to see a tip in LucidChart. Right-click the canvas to turn the cursor into a hand and drag to pan - no more finding and clicking the scroll bars! Please cover this feature in your support docs. Thanks!

Hi Folks - I've seen LucidChart used in the past to do space planning stuff and I'd like to try this.  I've seen the article online talking about how to select a floorplan template and adjust the scale et al but I'm still a bit stuck. Can anyone recommend a video and/or are there any training documents for using LucidChart to do space planning? As an example I need to build a 240' x 240' building and then place interior walls.  To be frank I'm not sure where to even start.   Thank you

Print and export options are not available for me (grey marked in list). Problem might be might be related to "offline" status. So how can I change to “online”; my internet connection is okay. If rootcause of not being able to print is not related to offline status, please suggest otherwise.

I am new to Lucid Charts. I am using floor plan. I dragged a room onto the canvas. I want to expand it to the right, but I cannot seem to select by clicking on it with my mouse. If I click in the center of the room nothing is selected. If I click on a wall, it only selects the wall. I assume I am misunderstanding something. Can you help? Thanks!

We use lucidchart as a frontend for an internal project roadmap tool. We are able to sync project tasks from a spreadsheet to custom lucidchart blocks but we still have to copy over dependencies manually. It would be very helpful to be able to sync lines between blocks. For example we have a "prerequisites" column in our spreadsheet. I would love to be able to assign the prerequisite to one of the connector handles on a task block and have lucidchart find another task corresponding to the prerequisite and draw a connection.

I have a spreadsheet which is driving a Smart Container document.  One of columns in the spreadsheet is a URL.   I would like to set an action on all of the objects in the Smart Container to go to the URL for that object. 1) Is it possible to base a link action on a data field at all? 2) is it possible to create a link action for all objects in a Smart Container document? This would be very powerful indeed if it were possible. Keith

I created a custom shape to display data for continual reporting. We have a progress bar so the status of the snap shot but it's being applied to each shape in the grouped shape. How can I get the rule to only apply to the parent shape of the group and not each individual shape within the group?

Hello I have some shapes linked to data and would like to be able to count how many of those shapes have any partiular piece of data. The shapes are linked to staff data so I would like to be able to have a formula to automatically count the number of staff with a particular skill set staff based in a particular location. etc etc Thanks  

Hi I have data linked custom shapes (grouped) and have used conditional formatting to apply different background colours based on the data linking. Is there a way to use a hotspot to toggle conditional formatting? As the shapes are grouped to allow custom icons to be activated/deactivated I am unable to use layers.

in the past we were able to import information into lucidcharts from google sheets using the org charts to document programming code for future reference with the recent changes to org charts our method no longer works. data linking doesn't seem to work for us either as we are now using custom shapes we need a way to take information from a spreadsheet (1) like the one pictured and using the custom shapes we've created (2) to document some coding for a very important project see example (3). the new Org charting doesn't work for what we are doing and the only way we've found so far is to copy text from the spreadsheet into the text fields of the related boxes i.e. Argument Name. this very time-consuming. and are wondering if there is an easier way. We've also tried data linking but that doesn't work well for us either (1)(2)

I've searched around to see if I could find something in your forums or documentation on this but couldn't find anything. What I'm hoping to do is to have data from one cell in a table on one of the pages in my document automatically copy to another cell in a table in a different page of the same document. I'm not sure if this is a feature already and I just can't find it or if this is something that would have to be added. To give an example this would be similar to the ability in Excel to write in a cell "=C4." Say I wrote that in cell A2. Then when I make a change to A2 C4 would show the same data. Is something like this possible within just Lucidchart without doing any Data Linking to some outside source?

I'm starting with the Gantt Chart with Progress Bar template and I've cloned the sample Google sheet and replaced the data with it. I see my changes to the existing rows/columns show up in Lucidchart when I click refresh. However the problem that is preventing me from doing anything useful is that I am unable to link additional cells/rows to data in the spreadsheet. I can copy a cell to an empty row but that seems to give me two cells in my diagram which are inextricably linked to the same cells on the Google sheet. I cannot figure out how to make the individual rows in the table each reference the corresponding row in the Google sheet. At this point it seems my diagram is irreparably broken in that multiple cells in it all reference the same row/cell in the Google sheet and I cannot find any way link more cells. I can find no way to add more rows to the Selected Shape Data panel which seems to control the table in the diagram. As is this data linking feature is comple