Skip to main content
Karen L101
November 22, 2022

Custom Formula and combining 2 statements

  • November 22, 2022
  • 3 replies
  • 56 views

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))

    Comments

    Phillip W
    Lucid support team
    November 23, 2022

    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 🍻

    Karen L101
    November 23, 2022

    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 

     

    Phillip W
    Lucid support team
    November 28, 2022

    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!