To create a countdown timer in Google Sheets, use the NOW() function to calculate the number of days, hours, and minutes. For days, use =INT (A2-NOW()), for hours, use =HOUR (A2-NOW()), and for minutes, use =MINUTE (A2-NOW()).