You are correct. PARENT refers to whatever contains the shape, which is the page unless the shape is in a container. You are looking for =FILLCOLOR(UPSTREAM). Note that UPSTREAM will pull a list of upstream elements if there is more than one. I hope this helps!

You are correct. PARENT refers to whatever contains the shape, which is the page unless the shape is in a container. You are looking for =FILLCOLOR(UPSTREAM). Note that UPSTREAM will pull a list of upstream elements if there is more than one. I hope this helps!

 

This now works:

but the problem arises when I try to put it in an if statement:

what is the problem?

Looks like it doesn’t consider the color a string. It works when I wrap “#ff0000ff” with HEXCOLOR. I found it by clicking the book in the bottom right of the formula to bring up the formula library and searching “color”.

Looks like it doesn’t consider the color a string. It works when I wrap “#ff0000ff” with HEXCOLOR. I found it by clicking the book in the bottom right of the formula to bring up the formula library and searching “color”.

 

Thank you so much!

another problem I’m encountering is that the block isn’t reformatting even though the upstream block is fulfilling the conditions, and says “true”. Do you see any potential fix?

Again, Thank you so much.

You’re welcome! Hm, mine is reformatting. That makes me think it’s one of two problems. Sometimes the conditional formatting rule won’t preview properly until you hit Save. Or, you may not have applied the rule to the shapes. You can either apply the rule to all shapes or select only the ones you want and apply to selected shapes. Let me know if that works.

You’re welcome! Hm, mine is reformatting. That makes me think it’s one of two problems. Sometimes the conditional formatting rule won’t preview properly until you hit Save. Or, you may not have applied the rule to the shapes. You can either apply the rule to all shapes or select only the ones you want and apply to selected shapes. Let me know if that works.

 

I just needed to put it on a new doc, thanks!

Here’s the final product I was working towards if you wanna check it out: https://lucid.app/lucidchart/3e549179-38d9-4de2-b50d-f05d45b5fb1d/edit?viewport_loc=-288%2C434%2C2297%2C1801%2C0_0&invitationId=inv_a66b22af-2ac8-4bc1-a762-789c88932709

you can change the circles from empty to 1 to use the logic gates

Nice! Wow, that’s super cool! Seems like a great way to teach people how logic gates work or to model out something you want to build.

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!