Formula help - still needs help answering ("best answer" selected by mistake)
I want to display the client name when conditions are met:
if the Client is active;
and if they have a spot airing on Monday,
and if the air time is 6:30am
the result in the new formula's field should be the name of the active client whose spot is to air at 6:30am Monday.
Established fields are for:
Active; Air Day; Air Time; Client Name