Skip to main content
Solved

why my formula isn't working?

Z
Forum|alt.badge.img+7
  • zerem
  • Known Participant
  • 17 replies

Hey friends
I'm trying to create a rating for my leads in the system based on all kinds of parameters - if they watched video 1, if they watched video 2, etc. For some parameters, I want to create 2 stars and some more. As in the example, if the customer is marked V on Facebook, he should receive 4 stars because this indicates a higher rating.
It doesn't work for me when I add the most stars.
I would appreciate the help and understanding of what I am doing wrong here.

Thank you!

 

Best answer by Databaser

Well, if your really want to hang on to your formula 😁

Try adding the If(Facebook... like you've added the video's and set "1" (x repeating) to "2" (x repeating). 

View original
    Did this topic help you find an answer to your question?

    9 replies

    Databaser
    Forum|alt.badge.img+19
    • Databaser
    • Inspiring
    • 866 replies
    • December 21, 2022

    Hi @zerem 

    Put the IF() statement first. No need to use "repeat". 

    IF(facebook, "⭐⭐⭐⭐", IF(OR({video 1}, {video 2}, {video 3}), "⭐⭐"))

     
    With this formula, if someone looked at 1 or 2 or 3 of the video's, they'll get 2 stars. If they watched Facebook, they'll get 4 stars.
    Jan - Databaser
    Z
    Forum|alt.badge.img+7
    • zerem
    • Author
    • Known Participant
    • 17 replies
    • December 21, 2022
    Databaser wrote:

    Hi @zerem 

    Put the IF() statement first. No need to use "repeat". 

    IF(facebook, "⭐⭐⭐⭐", IF(OR({video 1}, {video 2}, {video 3}), "⭐⭐"))

     
    With this formula, if someone looked at 1 or 2 or 3 of the video's, they'll get 2 stars. If they watched Facebook, they'll get 4 stars.

    hey cool thanks

    but I want it to get 2 stars for each video - so if someone saw video 2+3 he suppose to get 4 stars

    how can you do that?

    Databaser
    Forum|alt.badge.img+19
    • Databaser
    • Inspiring
    • 866 replies
    • December 21, 2022
    zerem wrote:

    hey cool thanks

    but I want it to get 2 stars for each video - so if someone saw video 2+3 he suppose to get 4 stars

    how can you do that?


    Add a formula field that counts the number of checks for the 3 videos:

    {video 1}+{video 2}+{video 3}
     
    Adjust the formula: 
    IF(facebook, REPT("⭐", (Score*2)+4))
     
    This will multiply the number of watched (checked) videos with 2 (so 1 video = 2 stars, 2 videos = 4 start and 3 videos = 6 stars) and add 4 stars if Facebook is (also) viewed/checked. So you get a max of 10 stars.
    Jan - Databaser
    Databaser
    Forum|alt.badge.img+19
    • Databaser
    • Inspiring
    • 866 replies
    • December 21, 2022
    Databaser wrote:

    Add a formula field that counts the number of checks for the 3 videos:

    {video 1}+{video 2}+{video 3}
     
    Adjust the formula: 
    IF(facebook, REPT("⭐", (Score*2)+4))
     
    This will multiply the number of watched (checked) videos with 2 (so 1 video = 2 stars, 2 videos = 4 start and 3 videos = 6 stars) and add 4 stars if Facebook is (also) viewed/checked. So you get a max of 10 stars.

    Edit: formula should be 

    IF(facebook, REPT("⭐", (Score*2)+4), REPT("⭐", (Score*2)))
     
    That way, if the Facebook field isn't checked it will still take the videos into account.
    Jan - Databaser
    Z
    Forum|alt.badge.img+7
    • zerem
    • Author
    • Known Participant
    • 17 replies
    • December 21, 2022
    Databaser wrote:

    Add a formula field that counts the number of checks for the 3 videos:

    {video 1}+{video 2}+{video 3}
     
    Adjust the formula: 
    IF(facebook, REPT("⭐", (Score*2)+4))
     
    This will multiply the number of watched (checked) videos with 2 (so 1 video = 2 stars, 2 videos = 4 start and 3 videos = 6 stars) and add 4 stars if Facebook is (also) viewed/checked. So you get a max of 10 stars.

    it's actually worked really good with the first formula

    just when I tried to add also another IF for the facebook it messed up the formula=

     

     

     

     

    Z
    Forum|alt.badge.img+7
    • zerem
    • Author
    • Known Participant
    • 17 replies
    • December 21, 2022
    zerem wrote:

    it's actually worked really good with the first formula

    just when I tried to add also another IF for the facebook it messed up the formula=

     

     

     

     


    any chance anybody knows how to fix it?

    Databaser
    Forum|alt.badge.img+19
    • Databaser
    • Inspiring
    • 866 replies
    • Answer
    • December 21, 2022

    Well, if your really want to hang on to your formula 😁

    Try adding the If(Facebook... like you've added the video's and set "1" (x repeating) to "2" (x repeating). 

    Jan - Databaser
    Z
    Forum|alt.badge.img+7
    • zerem
    • Author
    • Known Participant
    • 17 replies
    • December 21, 2022
    Databaser wrote:

    Well, if your really want to hang on to your formula 😁

    Try adding the If(Facebook... like you've added the video's and set "1" (x repeating) to "2" (x repeating). 


    haha Apologies, that's just the formula I was able to understand.
    If you can tell me in another way your formula I would prefer to use it.
    I just couldn't understand from what you wrote how to enter it.

    Z
    Forum|alt.badge.img+7
    • zerem
    • Author
    • Known Participant
    • 17 replies
    • December 21, 2022
    Databaser wrote:

    Well, if your really want to hang on to your formula 😁

    Try adding the If(Facebook... like you've added the video's and set "1" (x repeating) to "2" (x repeating). 


    it worked! thank you so much!

    Databaser
    1 person likes this
    • Databaser
      Databaser

    Reply


    Most helpful members this week

    Terms & Conditions