how can i use "If" with checkbox?

[zerem]

Hey friends
I want to create a star rating in the system based on V in existing checkboxes.
That is, if you watched video 1 - one star.
If you also watched video 2 - 2 stars
And so on.
How can you create such a thing?
That is, an IF that depends on a checkbox.

Thank you!

[Sara]

Hi, You can set up a series of automation, one for each video.

This is my dataset.

This automation will update when you click the checkbox "video 1".

This is for video 2, and you should set up the same for videos 3, video 4, and video 5.

Let me know if you have any questions 😊

[TheTimeSavingCo]

You could try this in a formula field:

IF({Video 1}, 1, 0) + 
IF({Video 2}, 1, 0)

[zerem]

and is it going to bring the "stars rating"?

[zerem]

good idea!

but it has to be 1 star for 1 video - I mean if someone jumps straight to video 2 - he doesn't have to get 2 stars but only 1.