I am hyperlinking a spreadsheet with dates, numbers and text - it's a living document and the "source of truth" will be added to throughout the course of time. I am looking to have all blank hyperlinked fields to show blank and all hyperlinked filled in cells to show appropriately ie whole number or date...but when I hyperlink blank cells I get a false date of 01/0/1900 and if I reformat each of those cells with 0;0;;@ it will show blank however, if I add a date in the "source of truth" that cell will reflect a whole number.
How do I get blank cells to show blank and still be hyperlinked so that when the source of truth is populated, the hyperlinked sheet is populated correctly?
=HYPERLINK
function?