Forum Discussion
LauraCawdronDav
3 years agoHelper I
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 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!
- Anonymous3 years ago
Hi,
I would suggest adding a custom column through power query that says:
if [Date] <> null then "Yes" else "No"
2 Replies
- AnonymousNot applicable
Hi,
I would suggest adding a custom column through power query that says:
if [Date] <> null then "Yes" else "No" - LauraCawdronDavHelper I
Thank you so much!