Formula if a certain cell is blank otherwise display the date in that cell.
What's wrong with his formula? I have also tried wrapping it in an if error. I am essentially trying to create a manual override for a date by formula. For example the formula inputs a start date of 1/23/24. If I manually enter a date into another Column I'd like it to show that date instead.
Here is the original formula that will spit a date out or a blank if there is no date in Construction Start
=IF(NOT(ISBLANK([Construction Start]@row), [Construction Start]@row + 21)
Here is the Formula that I am trying to achieve. If the GC start date is Blank the run the formula above. If it isn't blank then display the value.
=IF(ISBLANK([GC Start Date]@row), IF(NOT(ISBLANK([Construction Start]@row), [Construction Start]@row + 21), IF(NOT(ISBLANK([GC Start Date]@row)), [GC Start Date]@row)))
Help Article Resources
Check out the Formula Handbook template!