Display date from different row in same sheet
I have a Smartsheet with employee names, email and hire date.
Approximately every year employees are required to upload an updated resume, using a form to populate the sheet.
On that new row created by the form, the hire date is blank because employees can't be counted on to remember the correct date. We want to use the hire date entered previously by administrative staff when they were hired.
So something like this, if hire date is blank and the Email@row is somewhere else on the sheet, display Anniversary date.
Can someone assist? I'm thinking this might be an IF/Then formula but not sure.
Help Article Resources
Check out the Formula Handbook template!