Forum Discussion
Formula not inserting blank instead it defaults 12:00:00 AM
I have a Spreadsheet pulling data from a couple of cells and the issue i'm having is when the Ship time is blank my formula is putting in a default 12am time stamp instead of just showing a blank cel...
Since you lookup returns blank cells which are interpreted as zero time (0).
Fast workaround could be
=LET( ShipTime, XLOOKUP($B123,'Lavern File'!$B:$B,'Lavern File'!$K:$K, ""), IF($B$2="","", IF(ShipTime="", "",ShipTime) ) )
Since you lookup returns blank cells which are interpreted as zero time (0).
Fast workaround could be
=LET( ShipTime, XLOOKUP($B123,'Lavern File'!$B:$B,'Lavern File'!$K:$K, ""), IF($B$2="","", IF(ShipTime="", "",ShipTime) ) )
