Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

why my formula isn't working?

Solved
Jump to Solution
298 9
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

zerem_1-1671613512532.png

 

1 Solution

Accepted Solutions

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

See Solution in Thread

9 Replies 9

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?

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.

it's actually worked really good with the first formula

zerem_0-1671621373855.png

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

 

zerem_1-1671621562947.png

 

 

 

any chance anybody knows how to fix it?

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.

it worked! thank you so much!