Filter by Progress

Hello,

I am unable to find how to edit the filtering options for a progress column. The standard filters are > or < 20, >50, >80, and done. I would like to add a different percentage if possible.

Alternatively, perhaps I could add a formula column that uses the progress percentage column to input the percentage into a number column. However, my attempts to create this formula have failed.

Is anyone able to point me in the right direction? Thanks so much.

@rwilliams

It’s not elegant, but you can use the formula idea in this example to calculate the “%” done:

(
SWITCH({Status 1},"Done",1,0) +
SWITCH({Status 2},"Done",1,"Way Done",1,0) + 
SWITCH({Status 3},"Done",1,"Very Done",1,0) +
SWITCH({Status 4},"Done",1,"Very Done",1,0) +
SWITCH({Status 5},"Done",1,"Very Done",1,0)
)/5

Let me know if you need more.

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!
Check out our monday apps, now in beta: The Monday Man Apps

1 Like

Thank you very much @JCorrell . I will test this out and let you know how it goes. Good day.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.