IF formula from multiple cell information

I've been tasked to show the approval status of a row. Due to how I created the automation, depending on the level of an award (same sheet as referred to recently) the Manager signer may show status in 1 of 3 different columns. I want to do the colored circles at the beginning of the row. Would do gray if the column is blank, yellow if status is Submitted, red if Rejected, green if Approved.

Find more posts tagged with

Sheets

Formulas

Accepted answers

All comments

Bassam Khalil

Hi @Dale Callaway

Hope you are fine, please find in the following the required formula:

=IF([Submitted]@row = "Approved", "Green", IF([Submitted]@row = "Submitted" , "Red", "yellow"))

Dale Callaway

What do I put in if the column cell is blank instead of having Approved or Submitted?

Bassam Khalil

Dear @Dale Callaway

when the cell is blank it's yellow

Dale Callaway

Went a different direction. Thanks very much

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.