I am hoping this is a quick and easy fix. I've tried to research and I get answers explaining how to pull data, which I already know. Please see the formula lines below, the second line is returning data that was moved to a new spreadsheet. I only want Active Data from the RCCSM Employees spreadsheet.
=IF(ISBLANK('RCCSM Employees'!AK5),"TBD",'RCCSM Employees'!AK5)
=IF(ISBLANK('Retired-Term'!AL19),"TBD",'Retired-Term'!AL19)
=IF(ISBLANK('RCCSM Employees'!AK6),"TBD",'RCCSM Employees'!AK6)
Thanks
=IF(ISBLANK('RCCSM Employees'!AK5),"TBD",'RCCSM Employees'!AK5)
=IF(ISBLANK('Retired-Term'!AL19),"TBD",'Retired-Term'!AL19)
=IF(ISBLANK('RCCSM Employees'!AK6),"TBD",'RCCSM Employees'!AK6)
Thanks