I'm trying to create a custom formula to count the 'rectangle' objects that are Purple #9D99EC.
The page Insights "SHAPE" formula is showing as
=countif((descendants(page) x => itemtype(x) = 'Block')
I'm not sure how to combine the ISCOLOR and the below is giving me an error
=countif((descendants(page) x => itemtype(x) = 'Block') AND(ISCOLOR"#9D99EC"true))
Hey Karen
Thank you for posting in the Lucid Community! It looks like you are well on your way here however there is a slight tweak to the final formula that you will want to make in order to get this working properly.
Instead of using the formula you have listed there try using:
=countif(descendants(page) x => and(itemtype(x) = 'Block' lower(fillcolor(x)) = '#9d99ecff'))
This should allow you to accomplish what you are attempting.
Hope this helps--please reach back out if you have any other questions! Cheers
Thanks @phillip w This worked !!!... but then I try to replicate it for other fillcolor it doesn't.
How do I find the correct code as noticed the purple code you have has xxxx ff at the end
ie; aqua fill color i was trying says #31bddf when i hover over it but I get zero results when adding this to your formula
Hey Karen
Glad that worked! The ff represents 100% opacity. Here is a resource that explains this and gives the code for each opacity level.
Hope this helps--please let me know if you have any other questions!
Reply
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.