IF formula from multiple cell information

Dale Callaway · 01/19/21

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.

Bassam.M Khalil · 01/19/21

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 · 01/19/21

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

Bassam.M Khalil · 01/21/21

Dear @Dale Callaway

when the cell is blank it's yellow

Dale Callaway · 01/21/21

Went a different direction. Thanks very much

Explore. Ask. Answer.

IF formula from multiple cell information

Answers