Hi community! I browsed a bunch of examples, but haven’t find this specific case for Progress Bar.
I’m looking for a solution to automatically update value of Progress Bar based on value for column status in one table.
What I mean is:
- I want to auto update value for Progress Bar to 100, when Status for row is “Completed”
- When Status is “Canceled”, Progress Bar value should be 0
- Otherwise I want manually update status if condition 1 or 2 isn’t true
I tried to solve it via IF function, but it works only for auto-population and in this case I can’t manually update other rows.
Could you help me with that please?