If statement % complete column

ceej

I want to create an if statement in my % complete column such that % complete goes to 100% when another column has a date. 

Nic Larsen

Try (Change Due Date to your column name):

=IF(ISDATE([Due Date]@row), 1, 0)

ceej

Thanks! It works if I eliminate any dependency for the %change column.