Nov 03 2022 05:24 AM
i need a formula to use the job Req ID cell and input it into the weblink on the same line. i have manually inputted to the 1st line so what i need can be seen
some help would be much appreciated
Nov 03 2022 05:33 AM
Assuming that Job Req ID is in A2 and down: enter the following formula in D2, then fill down:
=IF(A2="","",HYPERLINK("https://careers.serco.com/job-invite/"&A2&"/")