If is blank and not blank formula

Raul Cabrera

Hi i have two columns with Date as column property “Next PoC Date” and “ Target end date” and i need to have an additional column that show me the following:

• If Next PoC Date is in blank show me “Target end date”
• If Next Poc Date is not blank, show me “Next PoC date”

All these in the same column. (This column will be the one that i will use to make a chart in Power BI)

Thanks for your help as usual.

Paul Newcome

You would use a basic IF statement like so…

=IF([Next PoC Date]@row = "", [Target End Date]@row, [Next PoC Date]@row)

Paul Newcome

You would use a basic IF statement like so…

=IF([Next PoC Date]@row = "", [Target End Date]@row, [Next PoC Date]@row)

Raul Cabrera

As usual thanks @Paul Newcome for your answer. Simple formula. I was triying to add the “ISBlank” into the formula when there was a simple way to formulate. Thanks again. Just for future reference who can see this post and try to find same solution, the extra column where it is the formula has to be Date property too, if not you will going to have an error of “invalid column value”.

Paul Newcome

Happy to help. 👍️