Forum Discussion

LauraCawdronDav's avatar
3 years ago
Solved

Using ISBLANK formula to create tickbox

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 NamePitch Date
A3 May 2022
B 
C 
D17 June 2021

 

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

 

Thank you!

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi,

     

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

     

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

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

     

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