Formula with symbols

Please help
Please help ✭✭
edited 02/02/24 in Formulas and Functions

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

Best Answer

  • =Chris Palmer
    =Chris Palmer ✭✭✭✭✭
    edited 01/31/24 Answer ✓

    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.

Answers

  • =Chris Palmer
    =Chris Palmer ✭✭✭✭✭
    edited 01/31/24 Answer ✓

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!