Formula with symbols

Please help

Hi. I have 10-20 columns that are all using the red, green, or yellow circle symbols for status. Is there a way to make a formula at the far last column that states when all columns are green circles the item is complete??

=Chris Palmer

Hello, @Please help

Is this what you're going for?

=IF(AND(

    [Column1]@row = "Green",

    [Column2]@row = "Green",

    [Column3]@row = "Green",

    [Column4]@row = "Green",

    [Column5]@row = "Green",

    [Column6]@row = "Green",

    [Column7]@row = "Green",

    [Column8]@row = "Green",

    [Column9]@row = "Green",

    [Column10]@row = "Green",

    [Column11]@row = "Green",

    [Column12]@row = "Green",

    [Column13]@row = "Green",

    [Column14]@row = "Green",

    [Column15]@row = "Green",

    [Column16]@row = "Green",

    [Column17]@row = "Green",

    [Column18]@row = "Green",

    [Column19]@row = "Green",

    [Column20]@row = "Green"), "Complete", "Incomplete")

If so, replace [Column##]@row with the actual name of your 10-20 columns.

=Chris Palmer

Hello, @Please help

Is this what you're going for?

=IF(AND(

    [Column1]@row = "Green",

    [Column2]@row = "Green",

    [Column3]@row = "Green",

    [Column4]@row = "Green",

    [Column5]@row = "Green",

    [Column6]@row = "Green",

    [Column7]@row = "Green",

    [Column8]@row = "Green",

    [Column9]@row = "Green",

    [Column10]@row = "Green",

    [Column11]@row = "Green",

    [Column12]@row = "Green",

    [Column13]@row = "Green",

    [Column14]@row = "Green",

    [Column15]@row = "Green",

    [Column16]@row = "Green",

    [Column17]@row = "Green",

    [Column18]@row = "Green",

    [Column19]@row = "Green",

    [Column20]@row = "Green"), "Complete", "Incomplete")

If so, replace [Column##]@row with the actual name of your 10-20 columns.