@Yamsanibhavani 

Override default will work when new record is getting created.

It should not impact during update record action.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader