Help! SWITCH formula not working

[zerem]

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!

[Databaser]

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.

[zerem]

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]

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.

[Databaser]

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.

[zerem]

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=

[zerem]

any chance anybody knows how to fix it?

[Databaser · Accepted solution]

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

[zerem]

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.

[zerem]

it worked! thank you so much!