I've tried a couple of things and I am at a loss.
I have a Planned Start Date, Planned End Date, and a % Complete column.
I would like the dots to be working as follows:
Red - When the planned start date prior to today and % complete is not = 100% or 1
Yellow - When the planned start date = today and the % complete is not = 100% or 1
All others Green
I've changed the formula several times and keep getting unparseable error.
I started with % Complete = 1, "Green", and then tried to add the others in
I've tried a lot......
This is what I have without the percent complete accounted for:
=IF([Planned End Date]@row < TODAY(), "Red", IF([Planned End Date]@row > TODAY(), "Green", IF([Planned End Date]@row = TODAY(), "Yellow")))
This works except I don't want Red if % complete = 100, etc.
I searched community and copied some formulas in and changed the fields but still get errors.
Any assistance appreciated.
Help Article Resources
Check out the Formula Handbook template!