Formula that changes status symbol based on check box checked/un-checked
I'm trying to create a formula that changes my status column to the red or green symbols.
I looked at some examples on the site, but wasn't able to get it to work on my sheet. I was trying to set up a formula around the following parameters..
If check box is checked then green
If check box is un-checked then red
I have used =IF([Renewal Date (Enter next Renewal Date)]@row > TODAY(), "Green", IF([Renewal Date (Enter next Renewal Date)]@row < TODAY(), "Red", "Yellow")) based on date column.
Thank you in advance for your help
Help Article Resources
Check out the Formula Handbook template!