Status dropdown Vs % Complete calculation

LisaB:-)

Hi, that's not working for me. The '100%' is populating regardless of the status of the Status column.

Paul Newcome

That's because the % Complete is based on the dates.

Try this...

=IF(Status@row = "Complete", 1, IF(Status@row = "Not Started", 0, IF((TODAY() - [Start Date]@row) / ([Finish Date]@row - [Start Date]@row) < 1, (TODAY() - [Start Date]@row) / ([Finish Date]@row - [Start Date]@row), 1)))

LisaB:-)

Thanks Paul, that seems to be working now :-)

Paul Newcome

Happy to help! 👍️