I have 2 lists. They both have Serial number as a column. list 1 is for jobs that need doing quarterly list 2 is for the engineers to add the jobs as they do them. This list also includes jobs that may not be on the quarterly checks list. i would like a way of list 1 updating the date completed by picking it up from list 2 IF the serial numbers match and it's marked as a scheduled job.
Should I try and use Flow? Calculated columns? We are on SharepointOnline.