How to add data to column based on specific conditions of an entry

[Gabriel Yeong]

Hi all, I'm stuck in the following:

Say I have the table below:

 

Date Group

01/01/2000 ABC

01/08/2000 XYZ

03/08/2000 DEF

12/25/2000 ABC

I want to add another column Called "ABC Group" where If Group = ABC, the row whould have the date, otherwise leave it as empty.

I placed the formula below, but it says "Invalid type for function call If"error, can anyone help

If([Group]="ABC ",[Date],"")

[Fabian Duerr]

It's all a matter of data types. Your [Data] column is a date but your ELSE statement "" is a empty string. This would cause two different data types in your new column. What you want to do is to use NULL instead.

If([Group]="ABC",[Date],NULL)