Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Re: why my formula isn't working?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Solved

Jump to Solution

1
1956
0

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 01:07 AM

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!

Solved! Go to Solution.

1 Solution

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 08:20 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 01:47 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 01:51 AM

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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 03:05 AM

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

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 03:07 AM

Edit: formula should be

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 03:19 AM

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=

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 08:12 AM

any chance anybody knows how to fix it?

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 08:20 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 08:22 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 21, 2022 08:30 AM

it worked! thank you so much!

Reply