Conditional formatting for "where % complete is not equal to 1" is not working

CpenceHuron

I have a project plan where I'm trying to set conditional formatting where % Complete is not equal to 1 and Finish Date is in the past, to turn row Yellow. It is not working. Please advise.

Paul Newcome

It looks like you are only changing the color of the "Task Bar" which is the bar that shows when viewing the sheet in Gantt view. To change the row, you need to change the cell fill which is controlled by the "bucket" on the left just above the task bar when editing the format.

Paul Newcome

Are you able to provide some screenshots for context?

CpenceHuron

CpenceHuron

Screenshot uploaded!

Paul Newcome

It looks like you are only changing the color of the "Task Bar" which is the bar that shows when viewing the sheet in Gantt view. To change the row, you need to change the cell fill which is controlled by the "bucket" on the left just above the task bar when editing the format.

CpenceHuron

Thank you so much Paul!

Paul Newcome

Happy to help. 👍️

CpenceHuron

HI Paul, while it is highlighting now, it doesn't seem to be using the logic, as rows that are 100% are being highlighted incorrectly.

Andrée Starå

https://community.smartsheet.com/discussion/comment/486927#Comment_486927

Hi,

I hope you're well and safe!

Change the % Complete to 1 instead. (= 100%)

Smartsheet sees the numbers in a column formatted for percentages as values between 0 and 1.
You'd need to use decimal values instead for it to work 

25% = 0,25 (0.25)
50% = 0,5 (0.5)
100% = 1

Depending on your country/region, you'll need to replace the comma with a period.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

CpenceHuron

Thank you much Andree.

Paul Newcome

Try changin git back to "is not equal to 1".

Andrée Starå

https://community.smartsheet.com/discussion/comment/486943#Comment_486943

Happy to help!

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏