I’m looking for some help to make a relation between my Done column and the Progress column for an interaction when we check one of the boxes and once all the tasks are done for this part, it will change the color according to the parameters added in the conditional format.

I know that the solution is not very complicated but I’m struggling a bit with this type of formula ^^.

Thank you in advance for the help you will give me,

Thanks in advance for any help you can give me. Sincerely,

Almost :), basically each time you have a goal it is divided into several subsections in the result key column.

When you have completed one of these subsections, you check the box in the Done column which will validate a percentage of the progress bar in the Progress column which in turn returns the result in the Objectives table.

I hope I have been more precise and I remain at your disposal to answer your questions

Last little point ^^, I don’t want the conditional format of the result column to be transferred to the progress column.

Thanks in advance for your help and don’t hesitate to use the page I’ve shared with you

Thanks @Dale_Cowling for your help it’s much better with one detail ^^ If(thisRow.Progress=100,True ,false() ) I had the solution because I had done If(thisRow.Progress=True,True() ,false() ) .

I don’t think I can take much credit for this one @Thierryvm, pretty sure I did nothing more than act as a sounding board at best. Glad you managed to find your solution regardless

This is used to count the total number of sub-objectives, so if you have 4 sub-objectives this column will show 4 etc.

The last column Percentage % is used to display the values in numerical form and this formula is used in the Progress column. The column must be in % format otherwise you will have to do *100

I hope this will help others to solve a problem and thanks again to @christiaan-huizer for all the help in understanding this problem.

Now that I can see the final solution I can say for sure that I was way off base with my what I thought you were aiming for

Just a thought on the execution. Could you delete the columns Partie and Total and place their formula into the formula for either Progress or Percentage.

I am not sure if this will have any impact on calculation performance but it will be cleaner. If you still need both Progress and Percentage to show as their own separate columns you can have one look at the other so only one of them has to run the calculation.

HI @Dale_Cowling
wonderful to see you helping so many people, merci!
you are right, the columns I instructed @Thierryvm are for educational purposes only, in my own docs I would have integrated the formula in the slider, but this is easier to understand for any newbie.
Cheers, Christiaan

I should have specified that this addition was for educational purposes and that you had performed tests on the progress bar directly, but for everyone to understand the logic behind it, I preferred to leave all the columns.

Otherwise, indeed, it was more judicious to realize the complete formula in the progress bar.

However, during our first tests, inconsistent values were obtained because it is currently impossible to put anything other than numerical values in the Maximum part which is by default 100 and for it to work properly, it should be possible to add a value in the form of %.

@christiaan_huizer, don’t hesitate to correct me if I have misunderstood or explained ^^