3 Replies Latest reply on Nov 8, 2011 3:47 PM by philmodjunk

    Formula help - still needs help answering ("best answer" selected by mistake)

    TomHartland

      Title

      Formula help - still needs help answering ("best answer" selected by mistake)

      Post

      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

      Help?