=IF statement referencing an entire column

Options

Hi community,

I'm wondering if there is a way to build an =IF formula while referencing an entire column. for example:

=IF([any value in column B]=A1, true, false)

Thanks!

Best Answer

  • Kelly Drake
    Kelly Drake Overachievers Alumni
    Answer ✓
    Options

    The formula is totally possible! To reference an entire column just use [Column Name]:[Column Name]

    You might need to do something like

    = IF(CONTAINS(A1, [Column B]:[Column B]), 1, 0)

    Kelly Drake (she/her/hers)

    STARBUCKS COFFEE COMPANY| business optimization product manager

Answers

  • Kelly Drake
    Kelly Drake Overachievers Alumni
    Answer ✓
    Options

    The formula is totally possible! To reference an entire column just use [Column Name]:[Column Name]

    You might need to do something like

    = IF(CONTAINS(A1, [Column B]:[Column B]), 1, 0)

    Kelly Drake (she/her/hers)

    STARBUCKS COFFEE COMPANY| business optimization product manager

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!