Changing option in multiselect column by hitting 100% in formula progress bar

How To
1

Hi! Ive made my reading tracker in notion and I wanted to ask if its possible to atumoaticlly change option in multiselect column (form “Reading” to “Read”) if column with my progress bar hits 100%?

I have column with total chapters and chapters already read then I have column with formula:
floor((prop(“Chapters read”) / prop(“Total chapters”)) * 100) / 100
so i can see in procentage how much of book I’ve read.

In other hand I have column with multiselect with “Want to read”, “Reading” and “Read”.

image

Is there any way i can do something like that?

2

You would need to run this scenario on schedule and a filter that allows it to pass only if that column is 100. You can then update the value by using an update module for notion.

Hope this helps!

3

Emm Im not english speaker and im confuzed hahahah cann you show me how to do this?? :sweat_smile: