I need help with a formula or direction if a formula isn't the best way to go

In my sheet I have 4 different dates , requested, procurement, legal and council, and I want the status to change when each date is filled. So if status has a date I want the one quarter symbol, procurement the half symbol, legal 3/4 symbol and council full. can someone help?

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

Leibel S

@LesahDee

If it is always in order (first, requested then procurement etc.), then us IF functions starting from the last one, so:

=IF(Council@row <>"","Full", IF(legal@row<>"","Three Quarter", and keep on going...

If they can each come at different times, you would use a count of how many are filled and then an IF function as above (starting from 4 and down)

LesahDee

Thank you I will try it

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.