Using ISBLANK formula to create tickbox

[LauraCawdronDav]

Hi,

I'm looking to create a new column which determines whether or not an opportunity we had included a pitch. The results would be based on there being a date in the 'Pitch date' column (True/Yes) or whether it's blank (False/No). Please can someone help me with the formula I need to do this? Example data below, table is called 'Opportunities'

Opportunity Name	Pitch Date
A	3 May 2022
B
C
D	17 June 2021

So in this instance A and D would be Yes, B and C would be no. 

Thank you!

[LauraCawdronDav]

Thank you so much!

[Anonymous · Accepted solution]

Hi,

I would suggest adding a custom column through power query that says:

if [Date] <> null then "Yes" else "No"