Formula for Status Bar

Nana250

Hello - Please help me build a formula with the below info:

Status Bar Column - I want to capture the progress of when a document is being signed with Empty, Quarter, Half, Full values.

Columns:

Date Received - when a date entered the status bar would change to quarter

Date Initialed - when a date is entered the status bar would change to half

Date Signed - when a date is entered the status bar would change to full

Name of Document - Status Bar Column would show empty when the document name is entered

Thank you for your help!

Paul Newcome

Try this:

=IF([Date Signed]@row <> "", "Full", IF([Date Initialed]@row <> "", "Half", IF([Date Received]@row <> "", "Quarter")))