NP2_✭✭

Comments

  • Thank you so much! That worked perfectly!
    inCreating training Calendar Comment byNP2_ 01/14/22
  • Another question for you.... Is there a way that I can make the row be flagged if a trainer has not been assigned, or the trainer assigned is overbooked (which has been changed to be more than one trainee at a time)? Here is my current formula: =IF(COUNTIFS([Assigned trainer]:[Assigned trainer], [Assigned trainer]@row,…
    inCreating training Calendar Comment byNP2_ 01/12/22
  • Genevieve, That worked! Thank you so much!
    inCreating training Calendar Comment byNP2_ 11/22/21
  • Here is my formula: =IF(COUNTIFS(Assigned trainer:Assigned trainer, Assigned trainer@row, [Start]:[Start], <=[Finish]@row, [Finish]:[Finish], >=[Start]@row) > 2, 1, 0) I used yours as my starting point, and changed the names of the rows in the formula to match my sheet. When I use it, it says #unparseable Thank you!
    inCreating training Calendar Comment byNP2_ 11/22/21
  • Hi Genevieve! I appreciate the help! I am having a few issues though... I edited the formula to match my column names but can't seem to get it to work. I also created the conditional formatting but it won't apply to the gnatt chart for some reason. Any suggestions? Thanks again!
    inCreating training Calendar Comment byNP2_ 11/19/21
Default Avatar