Conditional Formatting of imported data to static array of shapes?

First of all - thanks for bringing together all of the little pieces that make this work.

This worked well but I am seeing some odd behavior I don’t understand.  The saved custom shape worked wonders for automating the process.  That is all that I did - nothing more than was in the video.

When I drag the rows out onto a sheet the correct number come across AND the text is displayed.  Woo-hoo!  As advertised in the video.

What I don’t understand - what I didn’t see happen:

1. Several of the shapes are filled with color.  It appears to be random.  I didn’t do any conditional formatting.
2. How can I control the default number of rows & columns?
3. The shapes’ text is sorting A-z left to right.  Is there a way to control it A-z top to bottom?

I will see if I can discern the root of the evil but would appreciate any insights.

Hi Larry!

Some of this is hard to answer without seeing the doc:

1. If your attached spreadsheet has color formatting, that might be what’s coming over. But hard to say.
2. I’m not sure what you mean on rows and columns? Could you share a video or screenshot(s)?
3. Same as #2

I can also connect you with your account’s Solution Engineer, if that helps :)

Thank You for responding.
 

For item 1 I realized that there was conditional formatting in play.  I did not create the rule (I did create the drawing) so I am not sure of how it came to be.  I found it, corrected it, and moved on.

The other two questions were really about the initial placement of the shapes linked to rows pulled from the data.  I tried to see if I could affect the outcome of each but didn’t see a way to do so.  It simply becomes an exercise in field placement which is manageable.

I have time set up with my site engineer . . . so hopefully I’ll learn better ways to go about what I am doing with the data linking.

Cheers!

Ahh yeah, we just kind of get the shapes out there. I’m sure your SE will be able to help! :)

Hi @Larry Kemmerling! I’m Abby from Lucid, reaching out because I think you, and 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!