Hi everyone,
I am trying to automate symbols. The logic should be if the specific cell is below 90% then mark it as a red symbol, if it is greater than 90% mark it as yellow if it is greater or equal to 100% mark it green.
This is what I got:
=IF([Actual vs. Target Sq ft. Produced]@row < 0.9, "Red", IF([Actual vs. Target Sq ft. Produced]@row > 0.9, "Yellow", IF([Actual vs. Target Sq ft. Produced]@row >= 1, "Green")))
The symbol doesn't turn green when over 100%. Yellow and Red are working.
Thank you for the support.