Forum Discussion
Automatic entry of times based on conditions
Hello everyone. For weeks now, I've been going crazy looking for a way to solve the problem I'm about to present to you. I have attached the sheet I prepared. In the "HOUR" column there is a...
Now that there are no other times it is valid; but when I enter the times on the other dates (for example Monday 2 January), since it is no longer empty, it will return me twice on Monday.
What can be done to avoid this problem?
I thought that the idea was to use only formulas. If you're going to overwrite some of the formulas in column D with times, it won't work anymore, and I don't know how to repair that.