I have two date columns in a sharepoint list. I need to create a nested formula that will mark either -
"Open", Pending Open" or "Closed" (see attached file)
So I have three different scenarios to add to the formula. I am fine creating a formula for two different but not three.
Thanks for your help!