Column '' in Table '' contains blank values and this is not allowed for columns on the one side of a

[Anonymous]

Error I get: "Column '' in Table '' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table."

The formula is:

DateFormatted = if( [DATE] = today(),blank(),[Date])

It worked before. What is wrong?

[Kedar_Pande]

@Anonymous 

DateFormatted = 
IF(
[DATE] = TODAY(),
BLANK(), 
IF(
NOT(ISBLANK([DATE])),
[DATE],
DATE(9999, 12, 31) // Or any placeholder date that suits your model
)
)

By using this adjusted formula, you can maintain the integrity of your model without generating blank values where they're not allowed.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
The problem is here :
DateFormatted = if( [DATE] = today(),blank(),[Date])
blanks could not be used as a primary key.
You can have the wanted column but not to use it for creating relationship

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly