Return a value based on looking at two cells
Hello SS Community,
I am having a bit of formula writing block. I am trying to return a value based on looking at two cells. For example in the picture below.
If Onboarding Complete Date is blank and I9 Complete Date is blank, change the OB Status column to 'Awaiting Talent Paperwork'
If Onboarding Completed Date is populated and the I9 completion date is blank, change the OB status column to 'Awaiting I9 Section 2'.
If Onboarding Completed Date is populated and the I9 completion date is populated, change the OB status column to "Complete'.
Any assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!