Hi
I'm trying to create a conditional formula that will colour my gantt chart based on the progress percentage.
My formula =AND((G$6+6)>=start,G$6<=((end-start)*progress)+start) seems to fall apart in some instances and I can't figure it out for the life of me.
At 0% progress week 1 should be false etc; however works at 75% & 100% but not always.
Also have issues where the start & end dates are the same e.g 24/2/22 and 24/2/22, or start & end dates fall in the same week.
The gantt chart is tracked weekly. Where am I going wrong?
Here's a screenshot of me trying to sense check my formulas
I'm trying to create a conditional formula that will colour my gantt chart based on the progress percentage.
My formula =AND((G$6+6)>=start,G$6<=((end-start)*progress)+start) seems to fall apart in some instances and I can't figure it out for the life of me.
At 0% progress week 1 should be false etc; however works at 75% & 100% but not always.
Also have issues where the start & end dates are the same e.g 24/2/22 and 24/2/22, or start & end dates fall in the same week.
The gantt chart is tracked weekly. Where am I going wrong?
Here's a screenshot of me trying to sense check my formulas