Best Of

There is no way to get the display set as something different than the URL itself using formulas, but the API, the premium add-on Bridge, or other third party apps are able to do that.

Try something like this:
=IF([End Date]@row < TODAY(), "In the past", IF([Start Date]@row > TODAY(), NETWORKDAYS([Start Date]@row, [End Date]@row), NETWORKDAYS(TODAY(), [End Date]@row)))

This will return:
- "In the past" for anything that has an End Date in the past (can change to 0, or blank)
- The number of working days between the start/end for anything starting in the future
- The number of days remaining for anything that has already started and the end date is in the future.

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.