# Re: why my formula isn't working?

Solved
1956 0
cancel
Showing results for
Did you mean:
6 - Interface Innovator

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!

1 Solution

Accepted Solutions
12 - Earth

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

9 Replies 9
12 - Earth

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.
6 - Interface Innovator

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?

12 - Earth

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

{video 1}+{video 2}+{video 3}

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.
12 - Earth

Edit: formula should be

That way, if the Facebook field isn't checked it will still take the videos into account.
6 - Interface Innovator

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=

6 - Interface Innovator

any chance anybody knows how to fix it?

12 - Earth

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

6 - Interface Innovator

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.

6 - Interface Innovator

it worked! thank you so much!