I posted this once but don't know where it went:
I'm trying to populate a cell with TODAY() when another cell value is TRUE based on a checkbox.
I'm able to get the cell to change color with conditional formatting rules; however, it will not populate the date when entered as an option.
Basically, I have the checkbox in one column, TRUE or FALSE is reflected in the next column, and now I'm trying to get today's date to automatically populate based on the aforementioned cell being TRUE.
It changes colors based on the rule but doesn't enter the date; although, it's a rule option.
Any help is greatly appreciated! Formula?
Bookmarks