Hi, I'm trying to set up a formula to return the following information:
If the "Pad Possession" (a date) and the "Fixturing Period" (a number) both exist, then add the number of days to the date and return the new date.
If either or both of the Pad Possession or Fixturing Period cells are blank, then return "Awaiting Possession".
I used the "IFERROR" formula (pasted below), which works if either the Pad Possession or Fixturing Period cells are blank, but if both are blank then there is no error, and the formula returns nothing.
=IFERROR([PAD Possession Done / A&W Fixturing Started]@row + [Fixturing Period (Days)]@row, "Awaiting Possession")
Can anyone suggest how I can make this work? Thank you!
Help Article Resources
Check out the Formula Handbook template!