Make drop-downs reflect an in table % of completion (rectangle)

You can also use ‘Scale’ to create a kind of progress bar. There logic behind the percentage is very basic here, maybe you can automate the amounts by counting the elements. But I think you have to define thinks like the number of columns anyway, so it probably doesn’t really matter.

The formula of the progress bar checks each column value and looks for the percentage value in the steps table. You have to check, if the field is empty, otherwise you’d get an error. In the end it is rouneded up, so 9.9 (33,33 * 3) will result in 10

And of course this here is a great example for reactangle progress bars, where you can probably apply my logic too:

1 Like