How to obtain date values based on conditions?

Question

I added a custom column to say:

• If the Status column equals Active or Pending bring the date from the Office Date column.
• For any other values in the Status column, bring the date from the Incoming Date column.

All the rows with Active or Pending statuses have the correct dates from the Office Date column but everything else with the Incoming Date is showing as errors (from the second point).

Here is the code that I used: if [Status] = "Active" or "Pending" then [OfficeDate] else each [IncomingDate]

Is the part stating else each [IncomingDate] wrong?

Answer 1

Try this:

if [Status] = "Active" or [Status] = "Pending" then [OfficeDate] else [IncomingDate]