Good day all.
I am trying to display a blank cell if blank, nut I already have a formula in the cell.
Explination:
- I am tracking weeks below 70% in column L.
- In column K, I input the date the percentage fell below 70%. Bonus if the cell can auto populate the day it falls below 70% and remove once it goes above. (if bonus cred can be given)(not priority, a nice to have)
- Main issue: I want to display a blank cell in Column L if the date in Column K is blank, and keep my formula in Column L. AS you can see Column L displays over 6000 weeks if K is blank.
I have searched online and through here and cannot seem to find what I am looking for.
Thank you
Nvable.
Bookmarks