They're both common, correct, and natural. "For" focuses on the continual absence of sleep. " "In" focuses on the absence of any occurrence of sleep.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.