Difficulties Nesting formula
I think I am close to the answer here but struggling to figure out what I need to add to the formula to. Looking for the formula guru's here. Here's what I need this formula to do. I think I am on the right path, hopefully.
- If "Lab Date Received" row is empty, return "Awaiting FER in Lab"
- If "Lab Start Date" is not empty AND "Lab Complete Date" is empty, return "In Process"
- If "Lab Start Date" AND "Lab completed date" row are not empty, return "Complete"
Do appreciate your time, and should we get an answer I will reverse engineer the appropriate formula to continue to learn. Appreciate your help.
Help Article Resources
Check out the Formula Handbook template!