Best Of

That works thanks you very much, I tried so many different thing and something as simple as forgetting to take the 1 out!

Should that last one be greater than or equal to 2001 instead of less than or equal to?

I didn't even notice that error. I fixed it, my bad! Silly mistake. Thanks for pointing it out, Paul! 😊

Many thanks, it worked :)

Regards,

Justin

Try these instead…

QC (also accounts for going into the next year):

=IFERROR(DATE(YEAR([Date Initiated]@row), MONTH([Date Initiated]@row) + 1, DAY([Date Initiated]@row)), DATE(YEAR([Date Initiated]@row) + 1, 1, DAY([Date Initiated]@row)))

QA:

=[Date Due (QC Conclusion)]@row + 15

Hello @Lisa McMunn

Try this:

1. Create a helper column (for example checkbox "Training Done" column) on your Associate Information Sheet
2. Add this formula:
   1. =IF(HAS({Badge # Column in Training Tracker Sheet},[Badge #]@row),1,0)

This will check a row where the Badge # in the Associate Information sheet is found in the Training Tracker. Just make sure to change the correct references in the formula.

Thank you both - this was it!

Wonderful! I'm glad we were able to get there in the end. 🙂