Required Google Sheets,Microsoft Excel freelancer for Need help for Google Sheets job

There are 4 jobs which I will share a video link with shortlisted candidates

Job 1: Automatically add timestamp (that won't be overwritten) in column C when column M is filled Job 2: Automatically add timestamp (that won't be overwritten) in column T when column S is filled in Job 3: Automatically add a date and time (that won't be overwritten) in column O when column M is filled in. The time will be 'x number of working days' after depending on the value in column M Job Job 4: The Order Number in column A needs to autofill when Column M is filled in. The first part can be taken from A1 each time i.e. 'CNJAN19'. And the second part is a 4-digit number that starts with 0001 and ascends with each new row of data that is added, i.e. the next order would be order 'CNJAN190002'

Skills & Expertise Required

Google Sheets Microsoft Excel