Pulling a value from a field utilizing an IF statement

Sam29

I am trying to complete a formula, and am getting an invalid column value, however. Can you help?

Trying to have the formula look at a Revised Due Date column and if it is blank to pull the Due Date column value. If it is not blank, pull the revised due date column value.

=IF(ISBLANK([Revised Due Date]@row), [Due Date]@row, [Revised Due Date]@row)

Jeff M.

I tested you formula before looking into a possible solution and it worked on my end. Invalid column value could mean that the column containing your formula is not set to "date" type column.

Try adjusting the column properties and see if that works for you.

Have a great night!

Jeff M.

I tested you formula before looking into a possible solution and it worked on my end. Invalid column value could mean that the column containing your formula is not set to "date" type column.

Try adjusting the column properties and see if that works for you.

Have a great night!

Sam29

I changed the property of my column to a date restriction and it worked! Thanks you!