Formula for Status Bar

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!

Find more posts tagged with

Formulas

status

Accepted answers

All comments

Paul Newcome

Try this:

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.