IF formula from multiple cell information

Dale Callaway

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 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